Re: Source code

[MichaelQuigley@xxxxxxxxxx]

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