From: Michael Ryan

Seems simple...I want a count of the number of rows in a table, put that count into a variable, and then display that variable. Anyone have a snippet? Thanks...

I saw a suggestion of SQL select count(*) from file; as one option for you.

If you're looking for the count of all records, no restrictions, you can probably also use RTVMBRD with NBRCURRCD

Or possibly i5_info

I don't think I've specifically tested either one, since any count I wanted was based on a WHERE clause in a query rather than the complete file.

Sean Porterfield

This email is confidential, intended only for the named recipient(s) above and may contain information that is privileged. If you have received this message in error or are not the named recipient(s), please notify the sender immediately and delete this email message from your computer as any and all unauthorized distribution or use of this message is strictly prohibited. Thank you.

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by 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.