Hp Integrity NonStop H-Series Instrukcja Użytkownika Pobierz pdf (Strona 38)

Table 5 Considerations (continued)

ConsiderationItem

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 TypeSQL/MX data TypeODBC data type

YesCHAR(n)CHAR(n)CHAR(n)

YesVARCHAR(n)*VARCHAR(n)*VARCHAR(n)

YesVARCHAR(n)VARCHAR(n)LONGVARCHAR

YesDECIMAL(p,s)DECIMAL(p,s)DECIMAL(p,s)

YesNUMERIC(p,s)NUMERIC(p,s)**NUMERIC(p,s)

YesSMALLINTSMALLINTSMALLINT

YesINTEGERINTEGERINTEGER

YesREALREALREAL

YesFLOAT(p)FLOAT(p)FLOAT(p)

YesDOUBLE PRECISIONDOUBLE PRECISIONDOUBLE PRECISION

NoNot supportedNot supportedBIT

NoNot supportedNot supportedTINYINT

38 Compatibility and considerations

1 2 ... 33 34 35 36 37 38 39 40 41 42 43 ... 61 62

Komentarze do niniejszej Instrukcji

Brak uwag

Hp Integrity NonStop H-Series Instrukcja Użytkownika Strona 38

Komentarze do niniejszej Instrukcji

Powiązane produkty i podręczniki dla Sprzęt komputerowy Hp Integrity NonStop H-Series