Create an SQL package

SQL packages are permanent objects used to store information related to prepared SQL statements. They are used by ODBC support when the "extended dynamic" box is checked on a data source.

To create an SQL package:

  1. In the System i Navigator window, expand the system you want to use.
  2. Expand Databases.
  3. Right-click the database you want to use, and select New SQL package.
  4. On the Create SQL package dialog, specify parameters as necessary.
  5. Click OK.

Basic parameters

Advanced parameters

For advanced parameters, click Advanced.