perhaps you're thinking of
GET DIAGNOSTICS :lastRow = DB2_LAST_ROW

DB2_LAST_ROW
For a multiple-row-fetch statement, a value of +100 might be returned if
the set of rows that have
been fetched contains the last row currently in the result table for
cursors that are fetching forward, or
contains the first row currently in the result table, for cursors that are
fetching backward. If the
number of rows returned is equal to the number of rows requested, then an
end of data warning may
not occur and DB2_LAST_ROW may not contain +100.
If a value of +100 for DB2_LAST_ROW is returned for a cursor that is not
sensitive to updates, a
subsequent FETCH would return with the SQLCODE set to +100 and SQLSTATE set
to '02000'. For a
cursor that is sensitive to updates, a subsequent FETCH might return more
data if any rows have been
inserted before the FETCH was executed.
For statements other than multiple-row-fetch statements, for
multiple-row-fetch statements that do
not contain the last row currently in the result table, for cursors that
are fetching forwards, or that do
not contain the first row currently in the result table, for cursors that
are fetching backwards, or if the
server only returns an SQLCA, the value zero is returned.

Charles

On Wed, Mar 8, 2023 at 1:23 PM Gerald Magnuson <gmagqcy.midrange@xxxxxxxxx>
wrote:

I am looping through a cursor, I do receive the sqlcod of -100 when I have
processed all records.
wasn't there something I could do to tell me that I have fetched my LAST
record?
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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.