Re: sql fetch, wasn't there something we could put in the sql select statement, or the sql fetch to "look ahead" to see if we are at the end

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.