The following table shows the default and supported mappings of DB2 ESQL data types to C++ data types. You can change an attribute's C++ data type in its properties notebook. An 'S' indicates that the mapping is supported (you can map the specified ESQL data type to the C++ data type). A 'D' indicates the default setting that Data Access Builder will use for mapping the ESQL type.
| C++ Attribute Type | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ESQL Type | short | int | long | float | double | char | char* | wchar- _t* |
IString | IDate | ITime | ITime- stamp |
IBinary- Coded- Decimal |
| SMALLINT | D | S | S | S | S | S | S | S | S | ||||
| INTEGER | S | S | D | S | S | S | S | S | S | ||||
| DOUBLE | S | S | S | S | D | S | S | S | S | ||||
| REAL | S | S | S | S | D | S | S | S | S | ||||
| FLOAT | S | S | S | S | D | S | S | S | S | ||||
| DECIMAL | S | S | S | S | S | S | S | S | D | ||||
| NUMERIC | S | S | S | S | S | S | S | S | D | ||||
| CHAR | S | S | S | S | S | D | S | S | S | S | |||
| VARCHAR | S | S | S | S | S | S | S | D | S | S | S | S | |
| LONGVARCHAR | S | D | |||||||||||
| CLOB | S | D | |||||||||||
| GRAPHIC | S | S | D | ||||||||||
| VARGRAPHIC | S | S | D | ||||||||||
| LONGVARGRAPHIC | S | S | D | ||||||||||
| DBCLOB | S | D | |||||||||||
| CHAR_FOR_ BIT_DATA |
S | D | |||||||||||
| VARCHAR_FOR_ BIT_DATA |
S | D | |||||||||||
| LONGVARCHAR_ FOR_BIT_DATA |
S | D | |||||||||||
| BLOB | S | D | |||||||||||
| BINARY | S | D | |||||||||||
| VARBINARY | S | D | |||||||||||
| LONGVARBINARY | S | D | |||||||||||
| DATE | S | S | D | S | |||||||||
| TIME | S | S | D | S | |||||||||
| TIMESTAMP | S | S | S | S | D | ||||||||
