HP Integrity NonStop H-Series - Manual (Page 38)

Table 5 Considerations (continued)
Consideration Item
This API does not support pattern value arguments for table names, and
returns an optimal set of columns that the SQLSpecialColumns API uniquely SQLSpecialColumns API
identifies a row in the table information for a specified table name in the
SQL/MX catalog.
This API does not support pattern value arguments for table names, and
returns index information for a specified table name in the SQL/MX catalog. SQLStatistics API
Returns all catalogs defined in the SQL/MX metadata. SQLTables API
When CatalogName is
SQL_ALL_CATALOGS
Returns all the schemas defined in the SQL/MX metadata. SQLTables API
When SchemaName is
SQL_ALL_SCHEMAS
Returns all object types defined in the SQL/MX metadata. SQLTables API
When TableType is
SQL_ALL_TABLE_TYPES
The drivers use SQL_ATTR_METADATA_ID to determine whether to upshift
a table name. This applies for catalog APIs SQLTables, SQLPrimaryKey,
and SQLStatistics. This does not apply to SQLColumns API. SQL Table Names, SQL Catalog and
Schema Names
For this API, SQL_DEFAULT_PARAM and SQL_LEN_DATA_AT_EXEC (length)
are not supported for the pcbValue argument. SQLBindParameter API
This API can send data in parts only for the SQL_LONGVARCHAR data type.
For all other data types, only the latest value in the rgbValue argument is
sent. SQLPutData API
For information on migrating SQL/MP ODBC client applications to SQL/MX environment, see
SQL/MX Comparison Guide for NonStop SQL/MP Users.
ODBC data types
Table 6 lists the compatibility of drivers for ODBC data types.
Table 6 ODBC Data Types
Supported by the driver? SQL/MP data Type SQL/MX data Type ODBC data type
Yes CHAR(n) CHAR(n) CHAR(n)
Yes VARCHAR(n)* VARCHAR(n)* VARCHAR(n)
Yes VARCHAR(n) VARCHAR(n) LONGVARCHAR
Yes DECIMAL(p,s) DECIMAL(p,s) DECIMAL(p,s)
Yes NUMERIC(p,s) NUMERIC(p,s)** NUMERIC(p,s)
Yes SMALLINT SMALLINT SMALLINT
Yes INTEGER INTEGER INTEGER
Yes REAL REAL REAL
Yes FLOAT(p) FLOAT(p) FLOAT(p)
Yes DOUBLE PRECISION DOUBLE PRECISION DOUBLE PRECISION
No Not supported Not supported BIT
No Not supported Not supported TINYINT
38 Compatibility and considerations