Re: Help with Date Last Used Reporting...

["Jim Franz" <franz400@xxxxxxxxxxxx>]

> I failed to see where your example of RTVQMQRY listed the files CREATED by
> a query.  Getting that part of Chuck's request sounds like a real trick.
I
> even tried RTVQMFORM.  Of course, even if 1 of the 2 above worked you'd be
> lost if they deleted the query but not the file.  But, it would be a
start.
> Are there any API's for this?
>

I see your point. I ASSUMED the RTVQMQRY would have the info. NOT.
I'm not familiar with the api's. I do see the Option 6 of WRKQRY (Print
definition)
does have the output file. Could not find any cmd to do the print
definition.
sorry
jim



>
>
> > 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...
> >
>
> The following will get you an outfile you can then query. I never trust
> what
> is on
> the *PRINT option is same as the outfile.
>
> DSPOBJD OBJ(*ALLUSR/*ALL) OBJTYPE(*ALL) DETAIL(*BASIC)
> OUTPUT(*OUTFILE) OUTFILE(QGPL/ZDSPOBJD)
>
> To get the files created by the queries, you will probably need to
RTVQMQRY
> the *qrydfn to get file info.
>                      Retrieve Query Mgmt Query (RTVQMQRY)
>
> Type choices, press Enter.
>
> Query management query . . . . . > WOCOM1            Query Name
>   Library  . . . . . . . . . . . >   BNCPGM                      Name,
> *LIBL, *CURLIB
> Source file  . . . . . . . . . . > QQMQRYSRC                 Name
>   Library  . . . . . . . . . . . >   QGPL                            Name,
> *LIBL, *CURLIB
> Source member  . . . . . . . . . > *QMQRY                Name, *QMQRY
> Allow information from QRYDFN  . > *YES          *NO, *YES, *ONLY
>
> then look or read the source (this one does not output a file)
> QGPL/QQMQRYSRC/WOCOM1
>
>  H QM4 05 Q 01 E V W E R 01 03 00/12/29 12:59
>  V 1001 050 Cancelled Work Orders with Commens
>  V 5001 004 *HEX
>  SELECT
>    ALL       T01.WO#, T01.WOSTAT, T01.WOREC8, T01.WOID#, T02.GCSEQ#, T
>              T02.GCUSR, T02.GCDAT8
>    FROM      BNCFIL/WO T01,
>              BNCFIL/WOCM T02
>    WHERE     WO# = GCWO
>      AND(    WOSTAT IN ('X', 'Z')
>      AND     WOREC8 >= 20001101)
>  ****************** End of data
>
> hope this helps
> jim
> ----- Original Message -----
> From: "Chuck Lewis" <clewis@iquest.net>
> To: "Midrange-L List" <MIDRANGE-L@midrange.com>
> Sent: Friday, December 29, 2000 11:44 AM
> 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
+---