SQL packages

An SQL package is an object that contains the control structure produced when the SQL statements in an application program are bound to a remote relational database management system (DBMS).

The DBMS uses the control structure to process SQL statements encountered while running the application program.

SQL packages are created when a relational database name (RDB parameter) is specified on a Create SQL (CRTSQLxxx) command and a program object is created. Packages can also be created with the Create SQL Package (CRTSQLPKG) command.

Note: The xxx in this command refers to the host language indicators: CI for ILE C, CPPI for ILE C++, CBL for COBOL, CBLI for ILE COBOL, PLI for PL/I, RPG for RPG/400®, and RPGI for ILE RPG.

SQL packages can also be created with the Process Extended Dynamic SQL (QSQPRCED) API. The SQL packages mentioned within this topic collection refer exclusively to distributed program SQL packages. The QSQPRCED API uses SQL packages to provide extended dynamic SQL support.