You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Getting Nosucess when runing appengine

1 reply [Last post]
Guest's picture
Guest

HI

when I am running Appengine it is going to No success and throwing the following error.

SQL error. Stmt #: 1604 Error Position: 0 Return: 8602 - [ IBM][CLI Driver] CLI0165E Err or in row. SQLSTATE=01S01 [IBM][CLI Driver][DB2] SQL0138 N The second or third argumen t of the SUBSTR function is ou t of range. SQLSTATE=22011 (SQLSTATE 22011) -138

Along with the error it is showing the Step name as

SELECT V.OPRID , V.OP2 FROM ( SELECT B.OPRID , CASE WHEN LEN GTH(rtrim(Substr (A.name , loc ate( ',' ,A.NAME) + 1)) || ' ' || RTRIM(Substr(A.name , 1 , (locate( ',' ,A.NAME) - 1)))) > 30 THEN substr( rtrim(Substr (A.name , locate( ',' ,A.NAME ) + 1 ,(LENGTH(A.name) - LENGT

while i tried to run the same SQL it was working fine

Can anybody suggest me about how to proceed further on this issue?

Regards
Kishore

Guest's picture
Guest (not verified)
Re: Getting Nosucess when runing appengine

Hi Kishore,

I hope you are passing wrong param to substr .

regards
senthil Kumar K

Post new comment

CAPTCHA
The question below is to prevent automated spam submissions.
1 + 6 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.