|
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.