The DROP PACKAGE statement includes the PACKAGE parameter for distributed relational database. You
can issue the DROP PACKAGE statement embedded in a program or using interactive SQL. When you issue a DROP PACKAGE statement, the SQL package and its description are deleted from the AS. This has the same result as a Delete SQL Package (DLTSQLPKG) command entered on a local system. No other objects dependent on the SQL package are deleted as a result of this statement.
You must have the following privileges on the SQL package to successfully delete it:
The following example shows how the DROP PACKAGE statement is issued:
DROP PACKAGE SPIFFY.PARTS1
A program cannot issue a DROP PACKAGE statement for the SQL package it is currently using.