Open System Services ODBC/MX Client Driver (SQL/MX 3.x)

ODBC/MX Client Overview
HP NonStop Open System Services ODBC/MX Client Driver—640328-001
1-8
Release Considerations and Restrictions
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.
SQLStatistics Function 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.
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.
SQLTables Function
When CatalogName is
SQL_ALL_CATALOGS
When SchemaName is
SQL_ALL_SCHEMAS
When TableType is
SQL_ALL_TABLE_TYPES
Returns all catalogs defined in the SQL/MX metadata.
Returns all schemas defined in the SQL/MX metadata.
Returns all object types supported by SQL/MX.
SQL Table Names
SQL Catalog and Schema
Names
The OSS ODBC/MX Client Driver uses
SQL_ATTR_METADATA_ID to determine whether to upshift a
table name. This applies for catalog API to SQLTables,
SQLPrimaryKey, and SQLStatistics. This does not apply to
SQLColumns.
Table 1-1. Release Considerations and Restrictions (page 2 of 2)