Delete Query (DLTQRY)

The Delete Query (DLTQRY) command deletes an existing query definition from a library.

Parameters

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

Query (QRY Parameter)

Specifies the qualified name of the query definition being deleted.

query-name
Specify the 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:

*LIBL
All libraries in the library list for the current thread are searched until the first match is found.
*CURLIB
The current library for the job is searched. If no library is specified as the current library for the job, the QGPL library is used.
*USRLIBL
Only the libraries in the user portion of the job's library list are searched.
*ALL
All libraries in the system, including QSYS, are searched.
*ALLUSR
All user libraries are searched. All libraries with names that do not begin with the letter Q are searched except for the following: 

#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

  1. 'xxxxx' is the number of a primary auxiliary storage pool (ASP).
  2. A different library name, in the format QUSRVxRxMx, can be created by the user for each previous release supported by IBM to contain any user commands to be compiled in a CL program for the previous release. For the QUSRVxRxMx user library, VxRxMx is the version, release, and modification level of a previous release that IBM continues to support.
library-name
Specify the name of the library to be searched.

Examples

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.

Error messages

None