Additional SQL data types for HCL OneDB

Additional HCL OneDB™ SQL data types for HCL OneDB have corresponding HCL OneDB ODBC Driver data types.

The following table lists the additional HCL OneDB SQL data types for HCL OneDB and their corresponding HCL OneDB ODBC Driver data types. To use the HCL OneDB ODBC driver SQL data types for HCL OneDB, include infxcli.h.
HCL OneDB SQL data type HCL OneDB ODBC driver SQL data type (fSqlType) Description
Collection (LIST, MULTISET, SET) Any HCL OneDB ODBC driver SQL data type Composite value that consists of one or more elements, where each element has the same data type.
DISTINCT Any HCL OneDB 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 HCL OneDB 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.