Home > IT Answers > AS/400 > AS400/Report 400- how to display last used date for report ?
Seeapeatea
5 pts.
 AS400/Report 400- how to display last used date for report ?
AS/400 Reports
We have an application that used REPORT400 to defined all reports for the application.

Is there any command to find out which reports are no longer in used (based on last used date)?



Software/Hardware used:
AS400, REPORT400 Rel.10.5
ASKED: August 19, 2009  11:36 AM
UPDATED: August 19, 2009  1:28 PM
RELATED QUESTIONS
Answer Wiki:
You can create a temporary file of source member information from a source file using the cl command dspfd with *mbrlist as information type to an output file. You can then query on output file and see the last used date, which is one of the fields available in the IBM created QWHFDML format, which is created by the dspfd command. Hope it helps. Display File Description (DSPFD) Type choices, press Enter. File . . . . . . . . . . . . . . > QDDSSRC Name, generic*, *ALL Library . . . . . . . . . . . > DEVLIB Name, *LIBL, *CURLIB... Type of information . . . . . . > *MBRLIST *ALL, *BASATR, *ATR... + for more values Output . . . . . . . . . . . . . > *OUTFILE *, *PRINT, *OUTFILE File attributes . . . . . . . . *ALL *ALL, *DSPF, *PRTF, *DKTF... + for more values File to receive output . . . . . > TEMPDDS Name Library . . . . . . . . . . . > TJHLIB Name, *LIBL, *CURLIB Output member options: Member to receive output . . . *FIRST Name, *FIRST Replace or add records . . . . *REPLACE *REPLACE, *ADD
Last Wiki Answer Submitted:  August 19, 2009  1:28 pm  by  Tjh   30 pts.
All Answer Wiki Contributors:  Tjh   30 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


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