MX 2.x)

ODBC/MX Client Overview

HP NonStop ODBC/MX Driver for Windows—527888-004

1-9

Release Considerations and Restrictions

SQLCancel Function In an ODBC 2.0 application, ODBC/MX implements the

SQLCancel function as an SQLFreeStmt with the

SQL_CLOSE option.

If the query is running, ODBC/MX tries to stop the server. If

the attempt is successful, the client application receives an

error and must reconnect.

In an ODBC 3.0 application with a query (or queries) running,

ODBC/MX behaves as it does for a 2.0 application. In an

ODBC 3.0 application with no query running, ODBC/MX does

not implement the SQLCancel function. The application is

responsible for closing the cursor.

SQLPrimaryKeys Function This function does not support pattern value arguments for

table names, and returns keys information for a specified

table name in the SQL/MX catalog.

If the table name and keys information is not in the SQL/MX

catalog, then it looks in the SQL/MP object (matching the

criteria) registered in the MP_PARTITIONS table (through

aliases) by looking up the catalog (where each table is

registered), and returns the keys information for that SQL/MP

table.

SQLSpecialColumns

Function

This function does not support pattern value arguments for

table names, and returns an optimal set of columns that

uniquely identifies a row in the table information for a

specified table name the SQL/MX catalog.

If the table name and optimal set of columns information is

not in the SQL/MX catalog, then it looks in SQL/MP object

(matching the criteria) registered in the MP_PARTITIONS

table (through aliases) by looking up the catalog (where each

table is registered), and returns the optimal set of columns

that uniquely identifies a row in the table information for a

specified table name.

Table 1-1. Release Considerations and Restrictions (page 2 of 3)