Re: Reporting using rtvdirinfo files

[Pat Barber <mboceanside@xxxxxxxxxxxxxxxx>]

Thanks...the machine I'm on doesn't have the interactive SQL,
so I got to revisit putting the statements in a text file as I recall.

I can barely remember how that worked.


rob@xxxxxxxxx wrote:

> You're going to have to do your analysis in SQL. 
>
> Try this (changing QAEZD0007 to what pertains in your situation)
> SELECT SUBSTR(char(QEZOBJNAM),1,30) AS ObjectName,
>       SUBSTR(char(QEZDIRNAM1),1,60) as DirName, 
> QEZOBJTYPE, QEZALCSIZE, QEZDTASIZE, 
> QEZACCTIM, QEZCHGTIMA, QEZCHGTIMD 
> FROM QUSRSYS/qaezd0007o O 
> JOIN QUSRSYS/QAEZD0007D D 
>  ON O.qEZDIRIDX = D.qEZDIRIDX 
> order by qezalcsize desc 
>
> Rob Berendt
>