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

declaring the cursor INSENSITIVE and then the get diagnostics did work
great.


On Wed, Mar 8, 2023 at 2:55 PM Javier Sanchez <
javiersanchezbarquero@xxxxxxxxx> wrote:

If you are not to read a dynamic, changing, cursor, what I do is declare it
INSENSITIVE and just after opening it:

exec sql get diagnostics :rowCount = DB2_NUMBER_ROWS;

This gives you exactly the number of rows the cursor will read for you.

HTH.

Javier.


El mié, 8 mar 2023 a las 14:23, Gerald Magnuson (<
gmagqcy.midrange@xxxxxxxxx>)
escribió:

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.

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