AW: 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

Hi ,

You can use : Exec SQL GET DIAGNOSTICS :rows = DB2_NUMBER_ROWS; to evaluate the number of rows after the cursor open statement

Mit freundlichen Grüßen / Kind regards / Bien à vous,

Seán Courtney



-----Ursprüngliche Nachricht-----
Von: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> Im Auftrag von Raul Alberto Jager Weiler
Gesendet: Thursday, 9 March 2023 00:58
An: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Betreff: 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

You can do "union all" to a constant set to hival, that way you can compare the data fetched to detect the Last record.

El mié, 8 de mar de 2023, 17:33, Brad Stone <bvstone@xxxxxxxxx> escribió:

The only thing I can think of is if you also get a count and count the
record count as you go though. But that's not 100% either.

Kinda like dow (not %Eof)... you need to do a read to trigger eof.

On Wed, Mar 8, 2023 at 2: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.

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