On 11-Aug-2015 14:21 -0600, Buck Calabro wrote:
On 8/11/2015 3:59 PM, Johh R. Smith, Jr. wrote:
I am looking for a system file that contains the following fields.

Active records
Deleted records

I know this can be obtained via DSPFD or APIs but the DSPFD option
is taking forever because the library is huge and I haven't spent
the time on the API yet to see how slow it is. I was hoping someone
knew of a file that already had the data and I could just read it.

SYSPARTITIONSTAT might help but I have a tickle in the back of my
head that this might not encompass all the files on the system.
Maybe program described files are missing?

If so, then code/run the query from the VIEW *minus* that selection. Because the VIEW almost certainly gets the rows from the *DBXREF [and lateral join to the UDTF that gets the member information], then there is a limitation for the capability to get data about files in QTEMP; presumably not an issue for the scenario described in the OP.

This thread ...


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

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