Owner's manual

Table 4 MXODSN and ODBCDSN attributes (continued)
DescriptionAttributesFile Section
1, tracing is on. By default, tracing is
off.
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 ODBC application directory. For
example, if you specify the TraceFile
as Tracefile = trfetch, the trace
file is created as
trfetch.6947088_1285815329 on
Linux systems.
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. The
default is 0.
DataLang
FetchBufferSize indicates the
buffer size to fetch rows. The range is
FetchBufferSize
between 0 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
Server
is running. The format is
TCP:number1:number2.
SQLFractionValue indicates the
fraction value for SQL_C_TIMESTAMP
SQLFractionValue
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 42)
SQLIntervalBehaviour includes
zeroes at the beginning or at end of an
SQLIntervalBehaviour
interval datatype for micro or nano
MXODSN and ODBCDSN file formats 31