Default forward data type mappings for Informix data sources

The following table lists the default forward data type mappings for Informix® data sources.

Table 1. Informix default forward data type mappings (Not all columns shown)
Remote Typename Remote Lower Len Remote Upper Len Remote Lower Scale Remote Upper Scale Remote Bit Data Remote Data Operators Federated Typename Federated Length Federated Scale Federated Bit Data
BLOB - - - - - - BLOB 2147483647 - -
BOOLEAN - - - - - - CHARACTER 1 - -
BYTE - - - - - - BLOB 2147483647 - -
CHAR 1 254 - - - - CHARACTER - - -
CHAR 255 32672 - - - - VARCHAR - - -
CLOB - - - - - - CLOB 2147483647 - -
DATE - - - - - - DATE 4 - -
DATE - - - - - - TIMESTAMP1 - 0 -
DATETIME2 0 4 0 4 - - DATE 4 - -
DATETIME 6 10 6 10 - - TIME 3 - -
DATETIME 0 4 6 15 - - TIMESTAMP(6) 10 6 -
DATETIME 6 10 11 15 - - TIMESTAMP(6) 10 6 -
DECIMAL 1 31 0 31 - - DECIMAL - - -
DECIMAL 32 130 - - - - DOUBLE 8 - -
DECIMAL 1 32 255 255 - - DOUBLE - - -
FLOAT - - - - - - DOUBLE 8 - -
INTEGER - - - - - - INTEGER 4 - -
INTERVAL - - - - - - VARCHAR 25 - -
INT8 - - - - - - BIGINT 19 0 -
LVARCHAR 1 32672 - - - - VARCHAR - - -
MONEY 1 31 0 31 - - DECIMAL - - -
MONEY 32 32 - - - - DOUBLE 8 - -
NCHAR 1 254 - - - - CHARACTER - - -
NCHAR 255 32672 - - - - VARCHAR - - -
NVARCHAR 1 32672 - - - - VARCHAR - - -
REAL - - - - - - REAL 4 - -
SERIAL - - - - - - INTEGER 4 - -
SERIAL8 - - - - - - BIGINT - - -
SMALLFLOAT - - - - - - REAL 4 - -
SMALLINT - - - - - - SMALLINT 2 - -
TEXT - - - - - - CLOB 2147483647 - -
VARCHAR 1 32672 - - - - VARCHAR - - -
Notes:
  1. The federated type is TIMESTAMP(0) if the date_compat configuration parameter is set to ON.
  2. For the Informix DATETIME data type, the Db2® federated server uses the Informix high-level qualifier as the REMOTE_LENGTH and the Informix low-level qualifier as the REMOTE_SCALE.

The Informix qualifiers are the "TU_" constants defined in the Informix Client SDK datatime.h file. The constants are:
0 = YEAR 8 = MINUTE 13 = FRACTION(3)
2 = MONTH 10 = SECOND 14 = FRACTION(4)
4 = DAY 11 = FRACTION(1) 15 = FRACTION(5)
6 = HOUR 12 = FRACTION(2)