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