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