Wouldn't it be easier to query the SYSTABLES file from the DB2 System
Catalog? You could select those that have FILE_TYPE = 'S'. Then you
could join to SYSPARTITIONSTAT to get the list of members and sum the
NUMBER_ROWS column? I guess you would need to do something if you needed
it by source type, but that's probably somewhere else in the System
Catalog--I'm just not sure where off the top of my head.

wdsci-l-bounces@xxxxxxxxxxxx wrote on 11/09/2011 01:00:12 PM:

----- Message from J.Beckeringh@xxxxxxxxxxxxxxxxxxxxxxxxxx on Wed, 9
Nov 2011 16:23:00 +0100 -----

To:

Rational Developer for IBM i / Websphere Development Studio Client
for System i & iSeries <wdsci-l@xxxxxxxxxxxx>

Subject:

Re: [WDSCI-L] Source code

Well, you could use RDP to write a program that:

- calls QUSLOBJ for every library to list all the *FILE objects in that
library
- calls QDBRTVFD for every *FILE object to determine whether it is a
source file
- calls QUSLMBR for every source file to list all the members in that
source file
- calls QUSRMBRD for every member to determine source type and number of

records

But then again, that would be possible with PDM / SEU as well :-)

Joep Beckeringh

This thread ...

Follow-Ups:

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