I can write it any way that I need to. I'm doing some testing using that in
interactive SQL - what is number_partitions? Is that the number of members?

... and it takes quite a while to run for a large number of members in the
file.

Tom


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Monday, April 02, 2012 2:29 PM
To: Midrange Systems Technical Discussion
Subject: RE: How many members in a file?

Are you allowed to use SQL imbedded into rpg? For example

select NUMBER_PARTITIONS into :NbrMbrs
FROM SYSTSTAT
WHERE SYSTEM_TABLE_SCHEMA='ROB'
and SYSTEM_TABLE_NAME='MYFILE'


Rob Berendt

This thread ...

Follow-Ups:
Replies:

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

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