Finding Files used by Query/400

5580 pts.
Tags:
*QRYDFN
*QRYDFN DB2UDB
Query/400
Somewhere I know I had notes and maybe code to do this, but the clock is ticking, so does anyone have the way to extract what files are being used in exisiting (old!) queries - *QRYDFN type I have an extract utility written, but it's old stuff, and iteratively prints and reads the output. this updates the 'last used' date of course, so then going back to see what hasn't been used and delete it would no longer work. Isn't there an API that does this?? Thanks for any input Folks

Answer Wiki

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

I had the same questions a year ago. 7-17-8 tag AS/400 Query.

With two different procedures, I was able to identify 1) all query input files. and 2) all query output files thanks to input from this website.

Here is one solution offered by TPINKY :

“Hello,

This website has step by step instructions to run this…

http://search400.techtarget.com/tip/0,289483,sid3_gci1038164,00.html ”
*******************************************************************************
And the solution to identify output files created by query:

http://archive.midrange.com/repository/extqrydef.htm

One of these procedures updates object last used for the qrydfn.

Discuss This Question: 2  Replies

 
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
  • Yorkshireman
    Great, thanks A little experimenting to avoid updating the last used, and something has to work out. Thanks again
    5,580 pointsBadges:
    report
  • Modiyooch
    basically, I created an output file of all objects *qrydfn and referred to that file to determine date last used. I then removed those queries and concentrated on the remaining queries for my project. One thing that I wanted to do, but never found a solution was to globally change a file across all queries. Mainly, the location of my input files had changed; not the file name itself.
    540 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