When the source is DB2 and the target is Informix, the following
restrictions and conversions are performed:
Table 37. Data Type Conversion: DB2 to Informix
| DB2 for OS/390 Source data type | Informix Target data type | Changes after Create Nickname | ||
|---|---|---|---|---|
| COLTYPE | LENGTH | SCALE | ||
| FOR BIT DATA(n) | CHAR(n) 1 |
|
|
|
| CHAR(n) | CHAR(n) |
|
|
|
| VARCHAR(<256) | VARCHAR(n) |
|
|
|
| VARCHAR(>=256) | TEXT |
|
|
|
| GRAPHIC(n) | BYTE |
|
|
|
| VARGRAPHIC(n) | BYTE |
| No updates occur after create nickname |
|
| LONG VARCHAR | TEXT |
|
|
|
| DATE | DATE |
|
|
|
| TIMESTAMP | DATETIME |
|
|
|
|
| YEAR TO |
|
|
|
|
| FRACTION(5) |
|
|
|
| TIME | DATETIME |
|
|
|
|
| HOUR TO |
|
|
|
|
| SECOND |
|
|
|
| SMALLINT | SMALLINT |
|
|
|
| INTEGER | INT |
|
|
|
| DECIMAL(n,m) | DECIMAL(n,m) |
|
|
|
| FLOAT | FLOAT |
|
|
|
|
1For CHAR data in Informix, a string is terminated when the
first non-printable character is encountered. In this example, the CHAR
FOR BIT data from DB2 for OS/390 could be truncated when stored in Informix,
making it appear as though X'00' is part of the string.
|