SQL Package

SQL packages are permanent objects used to store information related to prepared SQL statements. They can be used by the IBM iSeries Access for Windows ODBC driver and OLE DB provider and the IBM Toolbox for Java JDBC driver. They are also used by applications which use the QSQPRCED (SQL Process Extended Dynamic) API interface. The SQL packages created by ODBC and QSQPRCED are called extended dynamic SQL packages and are the subject of the following questions and answers. IBM® DRDA® also uses SQL package objects but they are considerably different in behavior and are not covered below.