Open System Services ODBC/MX Client Driver Manual for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

Table 2 -1 describes the format of the ODBCDSN file. (continued)
Contents and FormatFile Section
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 42)
SQLIntervalBehaviour includes zeroes
at the beginning or end of an interval
SQLIntervalBehaviour
datatype for micro or nano seconds.
SQLIntervalBehaviour has two values,
SYSTEM_DEFAULT and
MSDN_DEFAULT. If not specified, the
default is SYSTEM_DEFAULT. For more
information, see “SQL Interval
Behaviour property” (page 46).
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 48).
SQL_ATTR _CONNECTION
_TIMEOUT
• Number of seconds the driver waits
in an active connection with no
exchange of data before closing the
connection
• SYSTEM_DEFAULT = 60
• NO_TIMEOUT (driver waits until a
server becomes available or
ODBC/MX is stopped)
SQL_LOGIN _TIMEOUT
• Number of seconds the driver will
wait to establish a connection with
the ODBC/MX Server
• SYSTEM_DEFAULT = 60
• NO_TIMEOUT
SQL_QUERY _TIMEOUT
• Number of seconds the driver waits
before closing the cursor and
returning control to the client.
• SYSTEM_DEFAULT = 60
• NO_TIMEOUT (driver waits until
query completes)
Name of the catalog to be used. If not
specified, the value is taken from those
defined by the ODBC/MX service.
CATALOG
Name of the schema to be used. If not
specified, the value is taken from those
defined by the ODBC/MX service.
SCHEMA
Configuring Data Sources 27