Query usage utility

Tags:
AS/400
I need a way to display or print the following: query name files in query last date used I need this to clean up old files & queries. Thanks

Answer Wiki

Thanks. We'll let you know when a new response is added.

You can retrieve the inside-sql for each query with a RTV* command (i’ve forgot the exact name, something like rtvqmqrysrc)
You can retrieve last date usage with a DSPOBJD output(*outfile)

=============================================================

You can’t retrieve all the file names that might be in or used by a Query/400 query without some special programming. The file names won’t necessarily be in the source generated from RTVQMQRY. This is just one of the many reasons Query/400 use should have been discontinued some 15 years ago.

See this ITKnowledgeExchange <a href=”http://itknowledgeexchange.techtarget.com/itanswers/rtvqryf-back-in-time/#comments”>thread on Query/400 files</a> for a helpful aid.

Tom

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Dawn8160
    you can create a query using the dspobjd and then selecting the appropriate fields such as odldat. Be careful with this though because if an object has been copied from another library or the source has been copied the date may not be correct.
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following