Managing an SQL package

 

After an SQL package is created, you can manage it the same way as you manage other objects on the i5/OS^® operating system, with some restrictions.

You can save and restore an SQL package, send it to other systems, and grant and revoke a user's authority to the package. You can also delete it by entering the Delete Structured Query Language Package (DLTSQLPKG) command or the DROP PACKAGE SQL statement.

When a distributed SQL program is created, the name of the SQL package and an internal consistency token are saved in the program. These are used at run time to find the SQL package and verify that the SQL package is correct for this program. Because the name of the SQL package is critical for running distributed SQL programs, an SQL package cannot be moved, renamed, duplicated, or restored to a different library.

• 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.

• Modifying package authorizations
  For any programs created on i5/OS, you can change the users that are authorized to use that package.

• 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.

 

Parent topic:

Working with SQL packages