RE: SQL Result Count Question..

["Hatzenbeler, Tim" <thatzenbeler@xxxxxxxxxxxxx>]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
Thank you... I will check that variable out...


> -----Original Message-----
> From: Buck Calabro [SMTP:Buck.Calabro@commsoft.net]
> Sent: Tuesday, May 07, 2002 2:47 PM
> To:   midrange-l@midrange.com
> Subject:      RE: SQL Result Count Question..
>
> Tim wondered:
>
> >My question is this...  Do I have to loop
> >through all the lines in the result set
> >using fetch next, or is the a value I can
> >read after the SQL runs that contains the
> >number of rows?
>
> Predefined value SQLER3 (for RPG) provides the number of rows.
>
> It's in the manual.
> http://publib.boulder.ibm.com/pubs/html/as400/infocenter.html
> V5R1
>  Programming
>   SQL
>    SQL Reference (HTML)
>     Appendix B (SQLCA)
>      Field descriptions
> http://publib.boulder.ibm.com/pubs/html/as400/v5r1/ic2924/info/db2/rbafzms
> tf
> ielddescsqlca.htm#HDRFIELDDESCSQLCA
>
> A search for SQLER3 turned up 4 hits, including the above.
>
>   --buck
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
This e-mail message, including any attachments, is for the sole use of the
intended recipient(s) and may contain confidential or privileged
information.  Any unauthorized review; use, disclosure or distribution is
prohibited.  If you are not the intended recipient, please contact the
sender by reply e-mail and destroy the message.