DB2 Data types vs OLDB Data types
DB2 TYPE_NAME |
OLEDB DATA_TYPE |
SMALLINT |
DBTYPE_I2 |
INTEGER |
DBTYPE_I4 |
REAL |
DBTYPE_R4 |
FLOAT |
DBTYPE_R8 |
DOUBLE |
DBTYPE_R8 |
DECIMAL |
DBTYPE_DECIMAL |
GRAPHIC |
DBTYPE_STR |
VARGRAPHIC |
DBTYPE_STR |
CHAR |
DBTYPE_STR |
VARCHAR |
DBTYPE_STR |
CHAR () FOR BIT DATA |
DBTYPE_BYTES |
VARCHAR () FOR BIT DATA |
DBTYPE_BYTES |
NUMERIC |
DBTYPE_NUMERIC |
DATE |
DBTYPE_DBDATE |
TIME |
DBTYPE_DBTIME |
TIMESTAMP |
DBTYPE_DBTIMESTAMP |