Finding Files used by 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
Software/Hardware used:
Software/Hardware used:
ASKED:
July 7, 2009 2:05 PM
UPDATED:
July 8, 2009 1:56 PM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
Great, thanks
A little experimenting to avoid updating the last used, and something has to work out.
Thanks again
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.