×
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 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.