Question

  Asked: Mar 11 2008   4:10 PM GMT
  Asked by: Droutt


field description-is there a way to run a command over a library to generate an outfile


DDS, AS/400

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.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0



Use the following command to create a Outfile that you can run a Query against.

DSPFFD FILE(YOURLIB/*ALL) OUTPUT(*OUTFILE) OUTFILE(*LIBL/YOUROUTFILE)
  • AddThis Social Bookmark Button

Browse more Questions and Answers on AS/400.

Looking for relevant AS/400 Whitepapers? Visit the Search400.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register