CL Command Reference - DLTSQLPKG
CL Command List > DLTSQLPKG Reference
Description:
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 iSeries system where the SQL package being deleted is located.
To delete an SQL package on a remote system that is also an iSeries 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 an iSeries system:
. 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.
Restrictions:
. You cannot use the DLTSQLPKG command to delete an SQL package on a remote system. To delete an SQL package from a remote system, you can do one of the following:
¨C Use interactive SQL to run the CONNECT and DROP PACKAGE statements.
¨C Sign on the remote system and use a command local to that system.
¨C Create and run an SQL program which contains a DROP PACKAGE SQL statement.
. You must have object existence (*OBJEXIST) authority for the SQL package and read (*READ) authority for the library where the SQL package is located to use this command.
Examples:
DLTSQLPKG SQLPKG(JONES)
This command deletes the SQL package JONES.