Linux ODBC/MX Client Driver for SQL/MX Release 3.2 (H06.25+, J06.14+)

Table 2 MXODSN file format and attributes (continued)
DescriptionAttributesFile section
• INFO to trace details about calls
made.
• DEBUG to trace the internal details
about calls made for debugging an
issue.
TraceFile attribute indicates the trace
file name. The trace file is located in
the Linux ODBC application directory.
For example, if you specify the
TraceFile as Tracefile = trfetch,
the trace file is created as
trfetch.6947088_1285815329.
List of data sources, in the format
<DSN> = <description>.
[DataSourceName] attribute indicates
the driver.
<DSN> = <description>
[DataSourceName]
[ODBC Data Sources]
Description attribute describes the data
source.
Description
DataLang
[data-source-name]
, one section for each DSN
DataLang attribute indicates the
character set for SQL commands.
Default is 0.
FetchBufferSize
Server
SQLFractionValue
FetchBufferSize indicates the buffer size
to fetch rows. The range is between 0
SQLIntervalBehaviour
and 256 Kb. If set to
SQL_ATTR _CONNECTION
_TIMEOUT
SYSTEM_DEFAULT, the buffer size is 8
Kb (SYSTEM_DEFAULT). For a single
row, the value is 0.
SQL_LOGIN _TIMEOUT
SQL_QUERY _TIMEOUT
Server attribute indicates the IP address
or domain name where MXCS is
Catalog
running. The format is
TCP:number1:number2.
Schema
SQLFractionValue indicates the fraction
value for SQL_C_TIMESTAMP to be in
nanoseconds or microseconds. If set to
9, the fraction value is in nanoseconds.
If set to SQL_DEFAULT, not specified,
or set to a value other than 9, the
fraction value is in microseconds. For
more information, see “Timestamp
values with fraction” (page 27)
SQLIntervalBehaviour indicates whether
the Interval data type behavior must be
the same as MSDN behavior.
SQLIntervalBehaviour can have two
values, SYSTEM_DEFAULT and
MSDN_DEFAULT. If not specified, the
default is SYSTEM_DEFAULT.
SQL_ATTR_CONNECTION_TIMEOUT
indicates the wait time to close an idle
connection. If set to SYSTEM_DEFAULT,
the value is 60 seconds. If set to
NO_TIMEOUT, the driver waits until a
ODBC server becomes available or
MXCS is stopped.
SQL_LOGIN_TIMEOUT indicates the
wait time to establish a connection with
MXCS. If set to SYSTEM_DEFAULT, the
value is 60 seconds. If set to
18 Configuring data sources