| Where allowed to run: Interactive environments (*INTERACT *IPGM *IREXX *EXEC) Threadsafe: No |
Parameters Examples Error messages |
The Work with Tables (WRKTBL) command allows you to show a list of available tables.
Restrictions:
| Top |
| Keyword | Description | Choices | Notes |
|---|---|---|---|
| TBL | Table | Qualified object name | Required, Positional 1 |
| Qualifier 1: Table | Generic name, name, *ALL | ||
| Qualifier 2: Library | Name, *LIBL, *CURLIB, *USRLIBL, *ALLUSR, *ALL |
| Top |
Specifies the tables to be shown.
This is a required parameter.
Qualifier 1: Table
Qualifier 2: Library
#CGULIB #DSULIB #SEULIB #COBLIB #RPGLIB #DFULIB #SDALIB
Although the following Qxxx libraries are provided by IBM, they typically contain user data that changes frequently. Therefore, these libraries are considered user libraries and are also searched:
QDSNX QRCLxxxxx QUSRDIRDB QUSRVI QGPL QSRVAGT QUSRIJS QUSRVxRxMx QGPL38 QSYS2 QUSRINFSKR QMGTC QSYS2xxxxx QUSRNOTES QMGTC2 QS36F QUSROND QMPGDATA QUSER38 QUSRPOSGS QMQMDATA QUSRADSM QUSRPOSSA QMQMPROC QUSRBRM QUSRPYMSVR QPFRDATA QUSRDIRCF QUSRRDARS QRCL QUSRDIRCL QUSRSYS
| Top |
WRKTBL TBL(LIB1/ABC*)
This command displays the Work with Tables panel, showing a list of tables whose names begin with the letters 'ABC' that exist in library LIB1.
| Top |
*ESCAPE Messages
| Top |