× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



I'm getting this error in my joblog when trying to fetch result set from a stored-procedure call. Any help would be appreciated:

Open of member AILOGPF was changed to SEQONLY(*NO).
Space offset X'FFFFFFFF' or X'0000000000000000' is outside current limit
for object MSRL3G684APALHC 039457.
SQL system error.
Ownership of object GPTFLST in QTEMP type *USRSPC changed.
Locator RS not valid.
Cursor C1 not open.
Cursor C1 not open.


Below is the RPG code:
D rs s SQLTYPE(RESULT_SET_LOCATOR)
D PCBRcd E DS extname(AILPCBRS) qualified
D totalRow S 10i 0
D cuno S 7 0 inz(6176640)

/free

exec sql call AILPCBSP(:cuno, :totalRow);
exec sql associate result set locator (:rs) with procedure AILPCBSP;
exec sql allocate C1 cursor for result set :rs;
exec sql fetch C1 into :PCBRcd;
dow sqlCode = 0;
exec sql fetch C1 into :PCBRcd;
enddo;

exec sql close C1;

*inlr = *on;

/end-free




thanks

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.