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.
|