Linux ODBC/MX Client Driver for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

Table 3 MXODSN file format and attributes
DescriptionAttributesFile section
TraceStart can have two values, 0 or
1. If set to 0, tracing is off. If set to 1,
tracing is on. By default, tracing is off.
TraceStart[ODBC]
TraceFlags indicates the trace level. It
can have the following values:
TraceFlags
• ERROR to trace failed SQL calls and
communication problems.
• WARNING to trace the warnings.
• CONFIG to trace configuration calls.
• 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
TraceFile
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[data-source-name]
, one section for each DSN
DataLang attribute indicates the
character set for SQL commands.
Default is 0.
DataLang
FetchBufferSize indicates the buffer size
to fetch rows. The range is between 0
FetchBufferSize
and 256 Kb. If set to
SYSTEM_DEFAULT, the buffer size is 8
Kb (SYSTEM_DEFAULT). For a single
row, the value is 0.
Server attribute indicates the IP address
or domain name where MXCS is
Server
running. The format is
TCP:number1:number2.
SQLFractionValue indicates the fraction
value for SQL_C_TIMESTAMP to be in
SQLFractionValue
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)
SQLIntervalInsertion includes zeroes at
the beginning or end of an interval
SQLIntervalBehaviour
datatype for micro or nano seconds.
SQLIntervalBehaviour has two values,
SYSTEM_DEFAULT and
18 Configuring data sources