Re: Help with Date Last Used Reporting...

[Chuck Lewis <clewis@xxxxxxxxxx>]

THANKS Adam !

Forget ALL about that one !!!

That will at least get me out of writing programs do dig through the spool file 
and
grab this info (which I've done in the past for stuff and was JUST about to 
start
on for this one...) !!

Chuck


Adam Sawdy wrote:

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

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