SQL/MX Connectivity Service Manual (SQL/MX 2.x)

Starting, Configuring, and Managing MXCS
HP NonStop SQL/MX Connectivity Service Manual—524944-008
3-24
Configuring Data Source Attributes for SequeLink
FetchBufferSize Size of buffer in Kb used to fetch rows
•
Range: 0 to 256 Kb
•
SYSTEM_DEFAULT = 8Kb
•
Single row = 0
(use to get update on current operation
or when exercising Publish/Subscribe)
[data-source-name]
continued
Data Source
Attribute
Description
Server
FILE:<SYSTEM NAME>.<MXCS PROCESS
NAME>
for example, FILE:\NODE1.$ZODBC
or
LOCAL:
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 MXCS is
stopped)
SQL_LOGIN
_TIMEOUT
•
Number of seconds the driver will wait
to establish a connection with MXCS
•
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)
Table 3-9. Format of the MXODSN file (page2of3)
File Section Contents and Format