Communicator 3000 MPE/iX Release 6.0 (Platform Software Release C.60.00) (30216-90269)

230 Chapter 10
Technical Articles
Introducing ODBCLink/SE
• SQLSetStmtOptions are not supported.
The driver will return either of these messages:
Driver not Capable (SQLState S1C00)
Option value changed (SQLState 01S02)
Supported Data Types
ODBCLink/SE supports ALLBASE/SQL and IMAGE/SQL data types.
The following table shows the correspondence between ALLBASE/SQL
or IMAGE/SQL data types and ODBC data types.
Table 10-6 Supported Data Types
SQL_TXN_REPEATABLE_READ Repeatable Read (RR)
SQL_TXN_SERIALIZABLE Repeatable Read (RR)
SQL_TXN_VERSIONING Not Implemented
ALLBASE/SQL or IMAGE/SQL
Data Type
ODBC Data Type
CHAR, max length <255 SQL_CHAR
CHAR, max length >=255 SQL_LONGVARCHAR
VARCHAR, max length <255 SQL_VARCHAR
VARCHAR, max length >=255 SQL_LONGVARCHAR
BINARY, length <256 SQL_BINARY
BINARY, length >=256 SQL_LONGVARBINARY
VARBINARY <256 SQL_VARBINARY
VARBINARY >=256 SQL-LONGVARBINARY
LONG BINARY SQL_LONGVARBINARY
LONG VARBINARY SQL_LONGVARBINARY
INTEGER (32-bit) SQL_INTEGER
SMALLINT (16-bit) SQL_SMALLINT
DECIMAL (Internal representation is
packed decimal)
SQL_DECIMAL
Image Zoned (Z) SQL_DECIMAL
Image Packed (P) SQL_DECIMAL
Image I3 (48-bit integer) SQL_DECIMAL
Image I4 (64-bit integer) SQL_DECIMAL