Displaying AS/400 Physical Files and Fields Layouts

How can I determine what fields I want to query when using the DOCSQL CL command ?

1.) Use the Display File Field Definitions command to display field definitions: DSPFFD

Example: DSPFFD FILE(QIWS/QCUSTCDT)

2.) Use the WRKDBFutility to view a file as well as field definitions (Customers will probably not have this.)

ADDLIBLE WRKDBF

WRKDBF FILENAME(QIWS/QCUSTCDT)

3.) Use the WRKF command to determine which files reside in a library

Example to display a list of all files in a library: WRKF FILE(QIWS/*ALL)

4.) Use the Display File Description command to display basic info about an AS/400 file: DSPFD

Example: DSPFD FILE(QIWS/QCUSTCDT)

5.) Use the AS/400 interactive SQL utility to display files using SQL statements. Requires customer to have license for IBM SQL licensed product.

STRSQL