SQL package

 

An SQL package contains the access plans for a distributed SQL program.

An SQL package is an object that is created when:

• You successfully create a distributed SQL program by specifying the relational database (RDB) parameter on the CREATE SQL (CRTSQLxxx) commands.

• You run the Create SQL Package (CRTSQLPKG) command.

When a distributed SQL program is created, the name of the SQL package and an internal consistency token are saved in the program. They are used at run time to find the SQL package and to 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

• Restored to a different library

 

Parent topic:

Application program objects