Question

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.

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

DSPFFD FILE(YOURLIB/*ALL) OUTPUT(*OUTFILE) OUTFILE(*LIBL/YOUROUTFILE)