Home > IT Answers > AS/400 > field description-is there a way to run a command over a library to generate an outfile
Droutt
75 pts.
 field description-is there a way to run a command over a library to generate an outfile
AS/400, DDS
State audit being performed over all our tables in order to associate level of restriction to some data. I've been tasked to provide a report of all the fields defined in our tables - is there a way to run a command over a library to generate an outfile. Something like DSPPFD but need it to go against all the PF in the library.

Software/Hardware used:
ASKED: March 11, 2008  4:10 PM
UPDATED: March 11, 2008  5:13 PM
RELATED QUESTIONS
Answer Wiki:
Use the following command to create a Outfile that you can run a Query against. DSPFFD FILE(YOURLIB/*ALL) OUTPUT(*OUTFILE) OUTFILE(*LIBL/YOUROUTFILE)
Last Wiki Answer Submitted:  March 11, 2008  4:53 pm  by  Sysadm57   55 pts.
All Answer Wiki Contributors:  Sysadm57   55 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


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