Default reverse data type mappings for Informix data sources

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

Table 1. Informix default reverse data type mappings
Federated Typename Federated Lower Len Federated Upper Len Federated Lower Scale Federated Upper Scale Federated Bit Data Federated Data Operators Remote Typename Remote Length Remote Scale Remote Bit Data
BIGINT 1 - - - - - - DECIMAL 19 - -
BIGINT 2 - - - - - - INT8 - - -
BLOB 1 2147483647 - - - - BYTE - - -
CHARACTER - - - - N - CHAR - - -
CHARACTER - - - - Y - BYTE - - -
CLOB 1 2147483647 - - - - TEXT - - -
DATE - 4 - - - - DATE - - -
DECIMAL - - - - - - DECIMAL - - -
DOUBLE - 8 - - - - FLOAT - - -
INTEGER - 4 - - - - INTEGER - - -
REAL - 4 - - - - SMALLFLOAT - - -
SMALLINT - 2 - - - - SMALLINT - - -
TIME - 3 - - - - DATETIME 6 10 -
TIMESTAMP - 10 - - - - DATETIME 0 15 -
VARCHAR 1 254 - - N - VARCHAR - - -
VARCHAR 1 255 32672 - - N - TEXT - - -
VARCHAR - - - - Y - BYTE - - -
VARCHAR 2 255 2048 - - N - LVARCHAR - - -
VARCHAR 2 2049 32672 - - N - TEXT - - -
Note:
  1. This type mapping is valid only with Informix server Version 8 (or lower).
  2. This type mapping is valid only with Informix server Version 9 (or higher).

For the Informix DATETIME data type, the 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)