Deleting an SQL package using the Delete SQL Package (DLTSQLPKG) command

 

You can use the Delete Structured Query Language Package (DLTSQLPKG) command to delete one or more SQL packages. You must run the DLTSQLPKG command on the system where the SQL package being deleted is located.

You must have *OBJEXIST authority for the SQL package and at least *EXECUTE authority for the collection where it is located.

There are also several SQL methods to drop packages:

• If you have the DB2^® UDB Query Manager and SQL Development Kit licensed program installed, use Interactive SQL to connect to the application server (AS) and then drop the package using the SQL DROP PACKAGE statement.

• Run an SQL program that connects and then drops the package.

• Use Query Management to connect and drop the package.

The following command deletes the SQL package PARTS1 in the SPIFFY collection:

DLTSQLPKG  SQLPKG(SPIFFY/PARTS1)

To delete an SQL package on a remote i5/OS^® operating system, use the Submit Remote Command (SBMRMTCMD) command to run the Delete Structured Query Language Package (DLTSQLPKG) command on the remote system. You can also use display station pass-through to sign on the remote system to delete the SQL package. If the remote system is not an i5/OS operating system, pass through to that system using a remote workstation program and then submit the Delete SQL Package command local to that system.

 

Parent topic:

Managing an SQL package

 

Related reference

Delete Structured Query Language Package (DLTSQLPKG) command
Submit Remote Command (SBMRMTCMD) command