Home > IT Answers > AS/400 > AS/400 query
STCA
60 pts.
 AS/400 query
AS/400
How can I search a iSeries query by date?

Software/Hardware used:
ASKED: March 12, 2010  11:02 AM
UPDATED: March 13, 2010  1:17 PM
RELATED QUESTIONS
Answer Wiki:
I read your question as "..how can I find queries created within a certain period". Use the DSPOBJD command to create a temporary file with object information : <pre> DSPOBJD OBJ(mylib/*ALL) OBJTYPE(*QRYDFN) OUTPUT(*OUTFILE) OUTFILE(QTEMP/myfile) </pre> Run query on the file and you ill find the field with the objects creation date. Did I get your Q right? Good luck DanF
Last Wiki Answer Submitted:  March 12, 2010  2:27 pm  by  DanTheDane   2,540 pts.
All Answer Wiki Contributors:  DanTheDane   2,540 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Thanks “DanTheDane”. It worked fine when I queried the file.

“StefanTheSwede”

STCA
 60 pts.
 

If you could try to QUERY the system database and find all objects of *QRYDFN. I do not have access to a machine which gives me display/query authority to what I believe is the master database (QADBIFLD in library QSYS) but if this table is the master table of everything on the system this table would always be accurate.

By using this table you would have an accurate report of every object on the system.

RossHowatson
 195 pts.