SQL package names
IBM® i Access ODBC and OLE DB packages are named differently depending on the database that is accessed.
The database server is sometimes used as a gateway to other relational databases that use DRDA . The database server automatically creates one or more SQL packages on the target relational database. The package names are generated according to the attributes currently used by the database server.
Package name if not a Db2 for i relational database
The package is created in a collection called QSQL400 on the application server, when it is not a Db2® for i relational database (RDB). When it is not a IBM i application server, the package name is QZD abcde, in which abcde corresponds to specific parser options being used.
The following table shows the options for the package name.
Package name field options
Field | Field description | Options |
---|---|---|
a | Date format |
|
b | Time format |
|
c | Commitment control/ decimal delimiter |
|
d | String delimiter |
|
e | Maximum number of statements allowed for package |
|
Package names if the relational database is Db2 for i
When it is a IBM i application server, the package name is QZDA abcdef, in which abcdef corresponds to specific parser options being used.
When it is a IBM i RDB, the package is usually created in the QGPL library which most database access clients can customize.
Package name field options
Field | Field description | Options |
---|---|---|
a | Date format |
|
b | Time format and naming convention |
|
c | Commit level and decimal point |
|
d | String delimiter |
|
e | Number of sections in package |
|
f | Date and Time separation |
|