DLTSQLPKG (Delete Structured Query Language Package) Command Description
DLTSQLPKG Command syntax diagram
Purpose
The Delete Structured Query Language Package (DLTSQLPKG) command is used to delete one or more SQL packages.
DLTSQLPKG is a local command and must be used on the iSeries 400 where the SQL package being deleted is located.
To delete an SQL package on a remote system that is also an iSeries 400, 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 an iSeries 400:
- Use interactive SQL to run the CONNECT and DROP PACKAGE operations.
- Sign on the remote system and use a command local to that system.
- Create and run an SQL program that contains a DROP PACKAGE SQL statement.
Required Parameters
- SQLPKG
- Specifies the qualified name of the SQL package being deleted. A specific or generic SQL package name can be specified.
The name of the SQL package can be qualified by one of the following library values:
*LIBL: All libraries in the job's library list 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.
library-name: Specify the name of the library to be searched.
SQL-package-name: Specify the name of the SQL package being deleted.
generic*-SQL-package-name: Specify the generic name of the SQL package to be deleted. A generic name is a character string of one or more characters followed by an asterisk (*); for example, ABC*. If a generic name is specified, all SQL packages with names that begin with the generic name, and for which the user has authority, are deleted. If an asterisk is not included with the generic (prefix) name, the system assumes it to be the complete SQL package name.
Example for DLTSQLPKG
DLTSQLPKG SQLPKG(JONES)This command deletes the SQL package JONES.