Re: GET DIAGNOSTICS question

[Alan Cassidy <cfuture@xxxxxxxxxxx>]

Thanks Buck! I've been using the DIAGNOSTIC values, but that seems a 
more sure thing.

But wait, you need a SELECT to do the count, and you can't do it when 
you open a cursor. I don't think you would run the cursor and then do 
this count with the same SELECT statement, so how is this?

The SQL cursors I use take a long time. It's probably quicker for the 
second SELECT, but I don't think that much.

--alan

On 5/10/2023 9:30 AM, Buck Calabro wrote:
> On Wed, 10 May 2023 at 04:38, Reeve <rfritchman@xxxxxxxxx> wrote:
> > How do I determine the number of records in the cursor I've just opened?
> > GET DIAGNOSTICS  :x = ROW_COUNT  returns the number of rows processed--not
> > what I need here.  GET DIAGNOSTICS :x = DB2_NUMBER_ROWS seems to be the
> > right call but it gives me a nonsense (I think) number (14932) when there
> > are zero rows.  If I have zero rows available, I close the cursor, sleep,
> > wake up, open the cursor again, and check for available rows.
> If I want a count, I do SELECT COUNT(*) INTO...
> To me, the diagnostic counts always seemed more like approximations
> rather than actionable data.
>    --buck