| Where allowed to run: All environments (*ALL) Threadsafe: No |
Parameters Examples Error messages |
| Top |
| Keyword | Description | Choices | Notes |
|---|---|---|---|
| QRY | Query | Qualified object name | Required, Positional 1 |
| Qualifier 1: Query | Name | ||
| Qualifier 2: Library | Name, *LIBL, *CURLIB, *USRLIBL, *ALL, *ALLUSR |
| Top |
Specifies the qualified name of the query definition being deleted.
This is a required parameter.
The name of the query definition can be qualified by one of the following library values:
#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 |
Example 1: Deleting a Query Definition
DLTQRY QRY(LIB1/MYDEF)
This command deletes query definition MYDEF from library LIB1.
Example 2: Deleting a Query Definition from All Libraries
DLTQRY QRY(*ALL/MYDEF)
This command deletes all the query definitions named MYDEF on the system.
| Top |
None
| Top |