To figure out what fields to query when using the DOCSQL command:
- Use DSPFFD to display field definitions.
For example:
DSPFFD FILE(QIWS/QCUSTCDT)
- Use the WRKDBF utility to view a file and field definitions:
Note: You may not have this utility.
- ADDLIBLE WRKDBF
- WRKDBF FILENAME(QIWS/QCUSTCDT)
- 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)
- Use DSPFD to display basic info about an iSeries file.
For example:
DSPFD FILE(QIWS/QCUSTCDT)
- 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.
Last Modified On:
No, open a new Support Case