Re: fetching result set that is returned from a stored-procedure call

On 13-Dec-2011 12:57 , Hockchai Lim wrote:

Changed the program to check for SQL error and problem appears to be
happening on associate result set statement.
Here is the new joblog:
Open of member AILOGPF was changed to SEQONLY(*NO).
Space offset X'FFFFFFFF' or X'0000000000000000' is outside current
limit for object MSRL3G684APALHC 039746.
SQL system error. ====> In detail it says: Internal error type 3171
has occurred.
Ownership of object GPTFLST in QTEMP type *USRSPC changed.
Error occurred when running SQL statement. SQLSTATE = 5800, SQLCODE
= -901, PSSR ID = PSSR-002.

OK. But why continue keeping the details of the MCH0601 a secret? While the text-based nature of the list\NG with most clients insisting on wrapping at 72 to 80 bytes [without some effort to ensure otherwise] may make messages "ugly" when including spooled joblog text, please realize that continuing to use print-screen or copy\paste of the details from an interactive joblog instead, is not conducive to allowing someone to better assist.

Regardless, the -901 is an "internal error" which is in most cases indicative of a defect with the SQL; even if reflected only in a poorly programmed scenario for which the SQL chooses not to provide better error handler for something that might either be rather complex or just likely to be very rare. That is to suggest, if the embedded SQL is presumably coded properly but still giving this error, the best option is probably to apply any missing [DB group] PTFs, and report the problem if [after applying PTFs] the problem persists.

Regards, Chuck