Re: Help with Date Last Used Reporting...

[Carel Teijgeler <teygeler@xxxxxxx>]

Chuck Lewis wrote:

> Hi Folks,
>
> I need to provide a listing of all queries on the system as well as all
> files created by a query and the date last used...
>
> I know how to use the wrkobjpdm command with wildcards but it doesn't
> provide date last used. The dspobjd using *ALL for Object Name done to
> screen OR print file includes the Date Last Used. BUT if I send it to an
> outfile it does NOT include Date Last Used.
>
> Doing dspobjd with *ALL for Object Name to *PRINT with *Basic does not
> provide it. With *Full or *Service it does but it is one MOTHER of a
> report and would be a nightmare to dump to a DB file and edit...
>
> Am I missing a better way/is there some better way of doing this before
> I "reinvent the wheel" ?
>
> Thanks and Happy New Year - and we should ALL be more relaxed this year,
> eh ? ! :-)
>
> Chuck
>

The result of DSPOBJD command can also be directed to an outfile. I think that
file has the required information in it. Perhaps you can use that.

Regards,

Carel Teijgeler.

P.S. All on the list: Happy New Year.


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---