| Where allowed to run: All environments (*ALL) Threadsafe: No |
Parameters Examples Error messages |
The Delete Structured Query Language Package (DLTSQLPKG) command is used to delete an SQL package or group of packages.
DLTSQLPKG is a local command and must be used on the System i5 system where the SQL package being deleted is located.
To delete an SQL package on a remote system that is also an System i5 system, use the Submit Remote Command (SBMRMTCMD) command to run the DLTSQLPKG command on the remote system.
The user can do the following to delete an SQL package from a remote system that is not a System i5 system:
Restrictions:
| Top |
| Keyword | Description | Choices | Notes |
|---|---|---|---|
| SQLPKG | SQL package | Qualified object name | Required, Positional 1 |
| Qualifier 1: SQL package | Generic name, name | ||
| Qualifier 2: Library | Name, *LIBL, *CURLIB, *USRLIBL, *ALL, *ALLUSR |
| Top |
Specifies the SQL package to be deleted. Multiple SQL packages can be deleted by specifying a generic SQL package name.
Qualifier 1: SQL package
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 |
| Top |
None
| Top |