Saving and restoring SQL packages in the distributed relational database environment

 

When an application program that refers to a relational database on a remote system is precompiled and bound, an SQL package is created on the application server (AS) to contain the control structures necessary to process any SQL statements in the application.

An SQL package is an i5/OS^® object, so it can be saved to media or a save file using the Save Object (SAVOBJ) command and restored using the Restore Object (RSTOBJ) command.

An SQL package must be restored to a collection that has the same name as the collection from which it was saved, and an SQL package cannot be renamed.

 

Parent topic:

Save and restore processing for a distributed relational database

 

Related reference

Restore Object (RSTOBJ) command
Save Object (SAVOBJ) command