SQL Code -104 when calling the cursor second time

C_Kartika_C · New User Joined: 14 Jun 2006 Posts: 3

I have a service that is working fine when called for the first time from a calling programs. But when a call is made to it for the second time, it is returning -104 as SQL Code for thr first Cursor.
The cursor was properly closed but still returning the same error.
Thanks in advance

priyesh.agrawal · Posted: Tue Jan 16, 2007 10:17 am

Did you mean a cursor when fetched in a called program and opened in a calling program works fine for the first time, but gives SQL -104 for the second time.

Please post cursor declaration:-

C_Kartika_C · New User Joined: 14 Jun 2006 Posts: 3

the cursor is opened, fetched and closed in second program only.
Just the program is called by another calling program.
For first call, everything went fine, after the second call is made, when control goes to called program, at the open of first cursor -104 is returned.

DavidatK · Posted: Wed Jan 17, 2007 7:59 am

C_Kartika_C,

I don't see any reason that the cursor shouldn't be able to be opened/cloded multiple times. Is it possible that you may be corrupting storage the first pass through?

priyesh.agrawal · Posted: Wed Jan 17, 2007 8:05 am

SQL -104 is a syntax error problem... here is some details about -104 from abend assist...

Reason:-
ILLEGAL SYMBOL token VALID SYMBOLS ARE token-list
Description of -104:-A syntax error in the SQL statement was detected at 'token'.A partial list of valid tokens, 'token-list', is provided. This list assumes that the statement is correct up to that point, and only as many tokens are listed as will fit.
Response:-Examine the statement in the area of the specified token.If you are executing the SQL statement dynamically under TSO, be sure that if the data set containing the DSNHDECP load module has not been included in your LINKLSTxx, it has been included in STEPLIB statements in:1. The DB2 start-up procedure 2. The TSO logon procedure or batch job JCL.