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

Overview of MXCS
HP NonStop SQL/MX Connectivity Service Manual—640327-001
1-9
MXCS Features
Connection information
Session summary
•
Statement collection is typically used for monitoring query performance or to
identify usage patterns. Statement statistics report data about the following SQL
statements executed during statistics collection.
SQLExecDirect SQLExecute
SQLPrepare SQLFetch
See the MXCS online help that is available on NSM/web for detailed descriptions of the
statistics collected.
For information on configuring statistics collection, see Configuring Statistics Collection
on page 3-17.
MXCS Features
The MXCS 3.0 supports the following features:
•
Row size limit is increased to align with maximum block size 32768 for MX tables.
•
A clustering key length up to 2048 bytes is allowed for range and hash partitioned
MX tables.
•
SQL/MX connectivity supports the extended NUMERIC precision data type. The
precision of this data type is extended up to 128 digits for signed and unsigned
values. The extended NUMERIC precision data type is used to hold temporary
values while computing the result of arithmetic expressions.
Limitation of MXCS
An R 2.x version of Connectivity Drivers is not compatible with R 3.0 version of
Connectivity server. If you try to connect an R 2.x version of Connectivity Driver to an
R 3.0 version of Connectivity server, the behavior is unpredictable.
Unsupported NonStop ODBC Server Features
This release of MXCS does not support the following NonStop ODBC Server features.
TDS messages (for DBLib clients)
T-SQL
User catalog customization (supported in ANSI)
Pass-through commands
Named pipes and IPX/SPX network protocols