Home | Previous Page | Next Page   Data Types > SQL Data Types >

Additional SQL Data Types for Dynamic Server

The following table lists the additional Informix SQL data types for Dynamic Server and their corresponding Informix ODBC Driver data types. To use the Informix ODBC Driver SQL data types for Dynamic Server, 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. For more information, see Working with Rows and Collections.
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. For more information, see Working with Smart Large Objects.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]