Finding Files used by Query/400
Home > IT Answers > AS/400 > Finding Files used by Query/400
Yorkshireman
3200 pts.
0
Q:
Finding Files used by Query/400
*QRYDFN DB2UDB, Query/400, *QRYDFN
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
ASKED: Jul 7 2009  2:05 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Modiyooch
370 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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.
Last Answered: Jul 7 2009  4:04 PM GMT by Modiyooch   370 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Yorkshireman   3200 pts.  |   Jul 8 2009  10:47AM GMT

Great, thanks

A little experimenting to avoid updating the last used, and something has to work out.

Thanks again

 

Modiyooch   370 pts.  |   Jul 8 2009  1:56PM GMT

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.

 
0