Table 213 lists the data type mapping that is performed when the
source data type is an Informix data type.
Table 213. Data type mapping from Informix source data types
| Informix source data type | DB2 UDB mirror data type | DB2 Everyplace device data type | Cloudscape device data type |
|---|---|---|---|
| BLOB | unsupported | unsupported | unsupported |
| BOOLEAN | unsupported | unsupported | unsupported |
| BYTE | unsupported | unsupported | unsupported |
| CHAR(n) | CHARACTER | CHARACTER | CHARACTER |
| CHARACTER VARYING(m,r) | VARCHAR | VARCHAR | VARCHAR |
| CLOB | unsupported | unsupported | unsupported |
| DATE | DATE | DATE | DATE |
| DATETIME HOUR TO SECOND | TIME | TIME | TIME |
| DATETIME HOUR TO FRACTION | TIMESTAMP | TIMESTAMP | TIMESTAMP |
| DATETIME YEAR TO DAY | DATE | DATE | DATE |
| DATETIME YEAR SECOND | TIMESTAMP | TIMESTAMP | TIMESTAMP |
| DATETIME YEAR TO FRACTION | TIMESTAMP | TIMESTAMP | TIMESTAMP |
| DATETIME YEAR TO FRACTION(5) | TIMESTAMP | TIMESTAMP | TIMESTAMP |
| DECIMAL(p,s) | DECIMAL | DECIMAL | DECIMAL |
| DOUBLE PRECISION | DECIMAL | DECIMAL | DECIMAL |
| FLOAT(n) | FLOAT | VARCHAR | FLOAT |
| INT8 | BIGINT | VARCHAR | BIGINT |
| INTEGER | INTEGER | INTEGER | INTEGER |
| INTERVAL largest_qualifier(p) TO smallest_qualifier(s) | CHARACTER | CHARACTER | CHARACTER |
| LVARCHAR | VARCHAR | VARCHAR | VARCHAR |
| MONEY(p,s) | DECIMAL | DECIMAL | DECIMAL |
| NCHAR(n) | CHARACTER | CHARACTER | CHARACTER |
| NUMERIC(p,s) | NUMERIC | DECIMAL | NUMERIC |
| NVARCHAR(m) | VARCHAR | VARCHAR | VARCHAR |
| REAL | REAL | VARCHAR | REAL |
| SERIAL(n) | unsupported | unsupported | unsupported |
| SERIAL8 | unsupported | unsupported | unsupported |
| SMALLFLOAT | REAL | VARCHAR | REAL |
| SMALLINT | SMALLINT | SMALLINT | SMALLINT |
| TEXT | unsupported | unsupported | unsupported |
| VARCHAR(m) | VARCHAR | VARCHAR | VARCHAR |
Related reference