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

Table 3 MXODSN file format and attributes (continued)
DescriptionAttributesFile section
MSDN_DEFAULT. If not specified, the
default is SYSTEM_DEFAULT. For more
information, see “SQL Interval
Behaviour property” (page 31).
SQL Datetime Retrieval specifies how
the SQL/MP Datetime data type is
SQLDatetimeRetrieval
retrieved from the ODBC/MX driver.
SQLDatetimeRetrieval has two values,
SYSTEM_DEFAULT and
MSDN_DEFAULT. If not specified, the
default is SYSTEM_DEFAULT. For more
information, see “SQL Datetime
Retrieval property” (page 33).
SQL_ATTR_CONNECTION_TIMEOUT
indicates the wait time to close an idle
SQL_ATTR _CONNECTION
_TIMEOUT
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
SQL_LOGIN _TIMEOUT
MXCS. If set to SYSTEM_DEFAULT, the
value is 60 seconds. If set to
NO_TIMEOUT, the driver waits until a
connection is established with MXCS.
SQL_QUERY_TIMEOUT indicates the
wait time to close the cursor and return
SQL_QUERY _TIMEOUT
control to the Linux ODBC application.
If set to SYSTEM_DEFAULT, the value is
60 seconds. If set to NO_TIMEOUT, the
Linux ODBC/MX client driver waits till
the query completes.
Catalog indicates the catalog name. If
not specified, Linux ODBC/MX client
Catalog
driver uses the MXCS defined catalog
name.
Schema indicates the schema name. If
not specified, Linux ODBC/MX client
Schema
driver uses the MXCS defined schema
name.
List of drivers.
This value must match the driver name
defined by DataSourceName attribute
in the [ODBC Data Sources] section.
Driver = <Driver>[DataSourceName]
The following MXODSN file sample defines connections to three client data sources;
TDM_Default_DataSource, DS1, and DS2:
In this example, the attributes Catalog and Schema for data source DS1 are defined as DS1CAT
and DS1SCH.
[ODBC]
TraceFlags = 6
TraceStart = 0
TraceFile = trlog
MXODSN file format 19