Re: SQL Stored procedure returning cursor to client - how to tell how many rows?

Charles,

Not very sure about this but, Have you checked the GET DIAGNOSTICS
statement? It's able to retrieve a lot of info, including DB2 number of
rows...

HTH,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries


On Fri, Jun 18, 2010 at 3:12 PM, Charles Wilt <charles.wilt@xxxxxxxxx>wrote:

I've got an SQL stored procedure that returns a cursor to the client.

Is there anyway to tell inside the stored proc, how many rows are
available to be returned to the client?

Running on v5r4.

Thanks!
Charles
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.