Open System Services ODBC/MX Client Driver Manual for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

Table 1 –1. Release Considerations and Restrictions (continued)
and ODBC client from long running queries. If a query
exceeds the specified time before the data source returns
the result set, the OSS ODBC/MX Client Driver returns
HYT00 (Timeout expired) to the ODBC client.
In an ODBC 2.0 application when the query is not running,
ODBC/MX implements the SQLCancel function as an
SQLFreeStmt with the SQL_CLOSE option.
SQLCancel Function
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.x application with a query (or queries)
running, ODBC/MX behaves as it does for a 2.0
application. In an ODBC 3.x application with no query
running, ODBC/MX does not implement the SQLCancel
function. The application is responsible for closing the
cursor.
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.
SQLPrimaryKeys Function
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.
This function does not support pattern value arguments for
table names, and returns an optimal set of columns that
SQLSpecialColumns Function
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.
This function does not support pattern value arguments for
table names, and returns index information for a specified
table name in the SQL/MX catalog.
SQLStatistics Function
If the index and table 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), then returns the index information for that
SQL/MP table.
Returns all catalogs defined in the SQL/MX metadata.SQLTables Function
When CatalogName is
SQL_ALL_CATALOGS
Returns all schemas defined in the SQL/MX metadata.When SchemaName is
SQL_ALL_SCHEMAS
Returns all object types supported by SQL/MX.When TableType is
SQL_ALL_TABLE_TYPES
The OSS ODBC/MX Client Driver uses
SQL_ATTR_METADATA_ID to determine whether to upshift
SQL Table Names
Release Considerations and Restrictions 19