Additional SQL data types for Informix
Additional HCL Informix® SQL data types for Informix have corresponding Informix ODBC Driver data types.
The following table lists the additional HCL Informix SQL
data types for Informix and their corresponding Informix
ODBC Driver data
types. To use the Informix ODBC
driver SQL data types for Informix, include infxcli.h.
| Informix SQL data type | Informix ODBC driver SQL data type (fSqlType) | Description |
|---|---|---|
| Collection (LIST, MULTISET, SET) | Any Informix ODBC driver SQL data type | Composite value that consists of one or more elements, where each element has the same data type. |
| DISTINCT | Any Informix ODBC driver SQL data type | UDT that is stored the same way as its source data type but has different casts and functions |
| OPAQUE (fixed) | SQL_INFX_UDT_FIXED | Fixed-length UDT with an internal structure that has the same size for all possible values |
| OPAQUE (varying) | SQL_INFX_UDT_VARYING | Variable-length UDT with an internal structure that can have a different size for each different value |
| Row (Named row, unnamed row) | Any Informix ODBC Driver SQL data type | Composite value that consists of one or more elements, where each element can have a different data type. |
| Smart large object (BLOB or CLOB) | SQL_IFMX_UDT_BLOB SQL_IFMX_UDT_CLOB |
Large object that is stored in an sbspace on disk and is recoverable. |