HP Integrity NonStop H-Series User Manual

Page 31

Advertising
background image

Table 4 MXODSN and ODBCDSN attributes (continued)

Description

Attributes

File 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

Advertising
This manual is related to the following products: