• Subject: Re: Help with Date Last Used Reporting...
  • From: rob@xxxxxxxxx
  • Date: Fri, 29 Dec 2000 14:34:54 -0500


The List Objects (QUSLOBJ) API lets you generate a list of object names and
descriptive information.  I would recommend the OBJL0600 format.
http://publib.boulder.ibm.com/pubs/html/as400/v4r5/ic2924/info/apis/quslobj.htm


Rob Berendt

==================
Remember the Cole!


                                                                                
                                         
                    Chuck Lewis                                                 
                                         
                    <clewis@iquest.net>        To:     MIDRANGE-L@midrange.com  
                                         
                    Sent by:                   cc:                              
                                         
                    owner-midrange-l@mi        Subject:     Re: Help with Date 
Last Used Reporting...                    
                    drange.com                                                  
                                         
                                                                                
                                         
                                                                                
                                         
                    12/29/00 01:43 PM                                           
                                         
                    Please respond to                                           
                                         
                    MIDRANGE-L                                                  
                                         
                                                                                
                                         
                                                                                
                                         




Oh, well, been there, done that in the past :-)

Thanks Al !

Chuck

"Al Barsa, Jr." wrote:

> At 11:44 AM 12/29/00 -0500, you wrote:
>
> You need to re-invent the wheel.  DSPOBJD gives you the date last used,
and
> then you need to get at the field for date last used.
>
> Al
>
> >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
> >+---
>
> +--------------------------------------------------+
> | Please do not send private mail to this address. |
> | Private mail should go to barsa@ibm.net.         |
> +--------------------------------------------------+
>
> Al Barsa, Jr. - Account for Midrange-L
> Barsa Consulting Group, LLC.
> 400 > 390
>
> Phone:          914-251-1234
> Fax:            914-251-9406
> http://www.barsaconsulting.com
> http://www.taatool.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
+---



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

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.