Library | Support | Terms of use
Last updated: Wednesday, October 17, 2006
(C) Copyright IBM Corporation 2004, 2006. All Rights Reserved.
This information center is built on Eclipse. (http://www.eclipse.org)
Table 1 lists the data type mapping that is performed when the source data type is a DB2® Version 9.1 or DB2 Universal Database™ (UDB) Version 8.2 data type.
| DB2 Version 9.1 and DB2 UDB Version 8.2 source data type | DB2 Version 9.1 mirror data type | DB2 Everyplace® device data type | IBM® Cloudscape™ Version 10 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 VARYING |
| 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 |
| XML | unsupported | unsupported | unsupported |
Last updated: Wednesday, October 17, 2006