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 an application server (AS).

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

You must use a control language (CL) command to create an SQL package because 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

• Using the Create SQL Package (CRTSQLPKG) command
  You can enter the Create SQL Package (CRTSQLPKG) command to create an SQL package from a compiled distributed relational database program. You can also use this command to replace an SQL package that was created previously.

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

 

Parent topic:

Application development

 

Related reference

Distributed relational database statements
SQL package creation
Binding an application