Displaying iSeries Physical Files and Field Layouts

 

1. Use DSPFFD to display field definitions.

   For example:

   DSPFFD FILE(QIWS/QCUSTCDT)

2. Use the WRKDBF utility to view a file and field definitions:

   Note: You may not have this utility.

   1. ADDLIBLE WRKDBF
   2. WRKDBF FILENAME(QIWS/QCUSTCDT)
3. Use the WRKF command to determine which files reside in a library.

   For example: To display a list of all files in a library, use:

   WRKF FILE(QIWS/*ALL)

4. Use DSPFD to display basic info about an iSeries file.

   For example:

   DSPFD FILE(QIWS/QCUSTCDT)    

5. Use the iSeries interactive SQL utility to display files using SQL statements.

   Note: You must have a license for an IBM SQL-licensed product to use this utility.

   STRSQL

Not using SQL? Here's why you should be.