MX 2.x)

Overview of MXCS

HP NonStop SQL/MX Connectivity Service Manual—524944-008

1-9

Unsupported NonStop ODBC Server 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-15.

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

Migrating From a NonStop ODBC Server

Environment

You must migrate your NonStop ODBC Server applications if you plan to take

advantage of the compiler and executor features of SQL/MX for your applications. By

migrating your applications, you also take advantage of the ODBC 3.5 compliant API

driver. Like SQL/MX (BSR X3.135-1992), ODBC/MX is based on the ISO/IEC 9075-3

standard and documented by Microsoft in the ODBC 3.5 Programmer's Guide.

For detailed information on the necessary application and configuration modifications

for migration in both the server and the client environments, see Appendix A, Migrating

Applications from NonStop ODBC Server.