To figure out what fields to query when using the DOCSQL command:
 
  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.


Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: October 12, 2018