Re: Source code

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