Table 212 lists the data type mapping that is performed when the
source data type is a DB2 Universal Database data type.
Table 212. Data type mapping from DB2 Universal Database source data types
| DB2 UDB source data type | DB2 UDB mirror data type | DB2 Everyplace device data type | Cloudscape device data type |
|---|---|---|---|
| BIGINT | BIGINT | VARCHAR | BIGINT |
| BLOB(n [K|M|G]) | unsupported | unsupported | unsupported |
| CHAR(n) | CHARACTER | CHARACTER | CHARACTER |
| CHAR(n) FOR BIT DATA | unsupported | unsupported | unsupported |
| CLOB(n [K|M|G]) | unsupported | unsupported | unsupported |
| DATALINK | unsupported | unsupported | unsupported |
| DATE | DATE | DATE | DATE |
| DBCLOB(n [K|M|G]) | unsupported | unsupported | unsupported |
| DECIMAL(p,s) | DECIMAL | DECIMAL | DECIMAL |
| DOUBLE | FLOAT | VARCHAR | DOUBLE PRECISION |
| DOUBLE PRECISION | FLOAT | VARCHAR | DOUBLE PRECISION |
| FLOAT | FLOAT | VARCHAR | DOUBLE PRECISION |
| GRAPHIC(n) | GRAPHIC | CHARACTER | unsupported |
| INTEGER | INTEGER | INTEGER | INTEGER |
| LONG VARCHAR | LONG VARCHAR | VARCHAR | LONG VARCHAR |
| LONG VARCHAR FOR BIT DATA | LONG VARCHAR FOR BIT DATA | BLOB | LONG BIT VARTING |
| LONG VARGRAPHIC | LONG VARGRAPHIC | VARCHAR | unsupported |
| REAL | REAL | VARCHAR | REAL |
| SMALLINT | SMALLINT | SMALLINT | SMALLINT |
| TIME | TIME | TIME | TIME |
| TIMESTAMP | TIMESTAMP | TIMESTAMP | TIMESTAMP |
| VARCHAR(n) | VARCHAR | VARCHAR | VARCHAR |
| VARCHAR(n) FOR BIT DATA | VARCHAR() FOR BIT DATA | BLOB | BIT VARYING |
| VARGRAPHIC(n) | VARGRAPHIC | VARCHAR | unsupported |
Related reference