Re: Help with Date Last Used Reporting...

     Chuck,

        Try using the Retrieve Object Description(RTVOBJD) command.  It is not
an interactive command so it must be used in a CL.  It will return CL variables
for a multitude of uses.  I think the CL variable you are looking for is the
&USEDATE variable.

    Good luck.

 Adam Sawdy

-----Original Message-----
From: Chuck Lewis <clewis@iquest.net>
To: Midrange-L List <MIDRANGE-L@midrange.com>
Date: Friday, December 29, 2000 12:05 PM
Subject: Help with Date Last Used Reporting...


>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
>
>+---
>| 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
>+---

+---
| 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
+---