Hi Folks
When you have embedded SQL in an SQLRPGLE program you'll sometimes get a message like so:
(etc.)
There are several potential candidates in the program for this error - several SELECT INTOs that might return more than one row.
I would like to understand if/how I can isolate the exact lines of code. Line 24002 doesn't correspond with anything remotely relevant in the source, whether you take it at face value or treat it as 240.02 - I've compiled the program and checked the source generated in QTEMP/QSQLTEMP1 and that doesn't have any such line either.
The message doesn't indicate the key or the file or anything much of use.
Is there a way to trace it?
When you have embedded SQL in an SQLRPGLE program you'll sometimes get a message like so:
Code:
From module . . . . . . . . : QSQFETCH From procedure . . . . . . : CK_DEBUG Statement . . . . . . . . . : 24002 To module . . . . . . . . . : QSQFETCH To procedure . . . . . . . : CK_DEBUG Statement . . . . . . . . . : 24002 Message . . . . : Result of SELECT more than one row. Cause . . . . . : The result table of a SELECT INTO statement, a subquery,
There are several potential candidates in the program for this error - several SELECT INTOs that might return more than one row.
I would like to understand if/how I can isolate the exact lines of code. Line 24002 doesn't correspond with anything remotely relevant in the source, whether you take it at face value or treat it as 240.02 - I've compiled the program and checked the source generated in QTEMP/QSQLTEMP1 and that doesn't have any such line either.
The message doesn't indicate the key or the file or anything much of use.
Is there a way to trace it?
Comment