DB2 ESQL Data Type Conversion Table

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  


Change Attribute Properties