Open System Services ODBC/MX Client Driver for SQL/MX Release 3.2 (H06.25+, J06.14+)
Table 2 -1 describes the format of the ODBCDSN file. (continued)
Contents and FormatFile Section
[ODBC Data Sources]
• 1. List of data source name
definitions
• Driver name
One section per data source.[[data-source-name]]
Lists the attributes for each data
source.
DescriptionData Source Attribute
Character set of SQL commands.
Default = 0
DataLang
Text string comment describing the data
source.
Description
Size of buffer used to fetch rowsFetchBufferSize
• Range: 0 to 256 Kb
• SYSTEM_DEFAULT = 8Kb
• Single row = 0
(use to get update on current
operation or when exercising
Publish/Subscribe)
DescriptionData Source Description
IP address or domain name where
ODBC/MX server is running, in the
form: TCP:number1/number2
Server
If SQLFractionValue = 9, the fraction
value of SQL_C_TIMESTAMP variable
SQLFractionValue
is considered to be nanoseconds. If
SQLFractionValue is not specified or if
it is SQL_DEFAULT or another value
apart from 9, the fraction part of
SQL_C_TIMESTAMP variables is
considered to be microseconds. For
details, see “Timestamp Values with
Fraction” (page 41)
SQLIntervalBehaviour indicates whether
the Interval data type behavior must be
SQLIntervalBehaviour
the same as MSDN behavior.
SQLIntervalBehaviour can have two
values, SYSTEM_DEFAULT and
MSDN_DEFAULT. If not specified, the
default is SYSTEM_DEFAULT.
26 Configuring Client Data Source Attributes for ODBC/MX Connectivity










