Using the SQL DROP PACKAGE statement

 

The DROP PACKAGE statement includes the PACKAGE parameter for distributed relational database. You can issue the DROP PACKAGE statement by embedding it in a program or by using interactive SQL.

When you issue a DROP PACKAGE statement, the SQL package and its description are deleted from the application server (AS). This has the same result as a Delete Structured Query Language 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 system authority *EXECUTE on the referenced collection

• The system authority *OBJEXIST on the SQL package

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.

 

Parent topic:

Managing an SQL package

 

Related reference

SQL DROP statement