Client Data Types | DB2 UDB Data Types |
|---|---|
BIGINT | BIGINT |
BYTE VARYING(n) | Not supported |
BYTE(n)* | Not supported |
C | Not supported |
CHAR(n) Note: CHARACTER(n) is a synonym for CHAR(n). | CHAR(n) Note: The length specifier (n) is required in DDL statements. |
DATE | TIMESTAMP |
DECIMAL(p,s)* | DECIMAL(p,s)* If the money mapping of DECIMAL(19,4) is selected, all data declared as DECIMAL(19,4) is returned as money. |
FLOAT | FLOAT |
FLOAT4 | REAL |
FLOAT8 | FLOAT |
INTEGER | INTEGER |
INTEGER1 | SMALLINT |
INTEGER2 | SMALLINT |
INTEGER4 | INTEGER |
LONG BYTE* | BLOB |
LONG VARCHAR* | CLOB |
MONEY | FLOAT-Default money data type mapping DECIMAL(19,4)-Money data type mapping If you select the money mapping DECIMAL(19,4) for DB2 UDB, all data declared as DECIMAL(19,4) is returned as money. |
REAL | REAL |
SMALLINT | SMALLINT |
TEXT | Not Supported |
VARCHAR(n) | VARCHAR(n) Note: The length specifier (n) is required in DDL statements. |