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. |