Connection string keywords - Server properties
Use these IBM® i Access ODBC driver connection string keywords to change Server properties of the ODBC connection.
The following table lists connection string keywords for Server properties that are recognized by the IBM i Access ODBC driver:
Keyword | Description | Choices | Default |
---|---|---|---|
CMT or CommitMode | Specifies the default transaction isolation level. | 0 = Commit immediate (*NONE) 1 = Read committed (*CS) 2 = Read uncommitted (*CHG) 3 = Repeatable read (*ALL) 4 = Serializable (*RR) |
2 |
CONNTYPE or ConnectionType | Specifies the level of database access for the connection. | 0 = Read/Write (all SQL statements allowed) 1 = Read/Call (SELECT and CALL statements allowed) 2 = Read-only (SELECT statements only) |
0 |
DATABASE | Specifies the IBM i relational database
(RDB) name to connect. Special values for this option include specifying an empty-string or *SYSBAS. An empty-string indicates to use the user-profile's default setting for database. Specifying *SYSBAS will connect a user to the SYSBAS database (RDB name). |
IBM i relational database name | empty-string |
DBQ or DefaultLibraries | Specifies the IBM i libraries to add to
the server job's library list. The libraries are delimited by commas
or spaces, and *USRLIBL may be used as a place holder for the server
job's current library list. The library list is used for resolving
unqualified stored procedure calls and finding libraries in catalog
API calls. If *USRLIBL is not specified, the specified libraries will
replace the server job's current library list. Note: The first library
listed in this property will also be the default schema (or library
), which is used to resolve unqualified names in SQL statements. To
specify no default schema, a comma should be entered before any libraries.
|
IBM i libraries 75 entries are supported. Entries over 75 are ignored. |
QGPL |
MAXDECPREC or Maximum Decimal Precision | Specifies the maximum precision of decimal data that will be returned. | 31 or 63 | 31 |
MAXDECSCALE or Maximum Decimal Scale | Specifies the maximum scale used in arithmetic calculations involving decimal data. This value must be less than the value of MAXDECPREC. | 0 – 63 | 31 |
MINDIVSCALE or Minimum Divide Scale | Specifies the minimum scale used in arithmetic calculations involving decimal data. | 0 – 9 | 0 |
NAM or Naming | Specifies the naming convention used when referring to tables. | 0 = "sql" (as in schema.table) 1 = "system" (as in schema/table) |
0 |