Delete 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 enter the (DLTSQLPKG) command on the iSeries™ server 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 iSeries server, use the Submit Remote Command (SBMRMTCMD) command to run the Delete Structured Query Language Package (DLTSQLPKG) command on the remote server. You can also use display station pass-through to sign on the remote server to delete the SQL package. If the remote server is not an iSeries server, pass through to that server using a remote workstation program and then submit the Delete SQL Package command local to that server.