Re: Looking for a system file with member level information -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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.

Library
File
Member
Active records
Deleted records
Size

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 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.