DB2 UDB Data Types | Client Data Types |
|---|---|
BIGINT | BIGINT |
BLOB | LONG BYTE |
CHAR(n) | CHAR(n) CHARACTER(n) is a synonym for CHAR(n). |
CLOB | LONG VARCHAR |
DATALINK | Not Supported |
DATE | CHAR |
DBCLOB | Not Supported |
DECIMAL | DECIMAL If you select the money mapping DECIMAL(19,4), all data declared as DECIMAL(19,4) is returned as money. |
DOUBLE | FLOAT |
GRAPHIC | Not Supported |
INTEGER | INTEGER |
LONGVAR | VARCHAR |
LONGVARG | Not Supported |
REAL | REAL |
SMALLINT | SMALLINT |
TIME | CHAR |
TIMESTAMP | DATE |
VARCHAR(n) | VARCHAR(n) |
VARGRAPH | Not Supported |