Working with SQL packages

An SQL package is an SQL object used specifically by distributed relational database applications. It contains control structures for each SQL statement that accesses data on a server.

These control structures are used by the server at run time when the application requests data using the SQL statement.

There is no SQL statement for SQL package creation. You can create an SQL package in two ways:

  • Using the CRTSQLxxx command with a relational database name specified in the RDB parameter
  • Using the Create SQL Package (CRTSQLPKG) command

Start of changeIt is recommended that user use one of the options above to create an SQL package, however an implicit create package will be attempted if the package is not found. If the user profile exists at the application server, the owner of the package will be set to the owner of the application. If the user profile does not exist at the application server, the owner of the package will be set to the current user profile used to connect .End of change