DB2 Connector Options

You can assign connector options by setting USYS$DB2_PARAMS in the [DRIVER_SETTINGS] section of the assignment file. For all options, the default action is used by the connector, unless specifically overridden.

USYS$DB2_PARAMS Option { , Option_n}

Options

checks
default locking
field name size
field alignment:4
hold statements
identifiers
lock isolation
maxlockwait
nls
nulldefault
open statements
ri
segmented fields
step size
table name size
unicode
update isolation

Description

The syntax rules for USYS$DB2_PARAMS are as follows:

Each assignment can be no longer than one line in the assignment file.
Each option may be specified only once.
Multiple options must be separated by a comma.
Parameter names and their values must be separated by a colon (:)
The order in which the options are specified is not significant.
When a parameter name consists of more than one word, for example ‘segmented fields’, separate the words by exactly one space. Before or after the colon, an arbitrary number of spaces is allowed. For example:

USYS$DB2_PARAMS = segmented fields : enabled
Options are case-insensitive.