Default reverse data type mappings for Db2 data sources

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

Table 1. Db2 default reverse data type mappings (Not all columns shown)
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 Federated Bit Data
BIGINT - 8 - - - - BIGINT - - -
BINARY - - - - Y - BINARY - - Y
BLOB - - - - - - BLOB - - -
BOOLEAN - - - - - - BOOLEAN - - -
CHARACTER - - - - - - CHAR - - N
- - - - Y - CHAR - - Y
CLOB - - - - - - CLOB - - -
DATE1 - 4 - - - - DATE - - -
- 4 - - - - TIMESTAMP(0) - - -
DBCLOB - - - - - - DBCLOB - - -
DECIMAL - - - - - - DECIMAL - - -
DECFLOAT2 - 8 - - - - DECFLOAT - 0 -
- 16 - - - - DECFLOAT - 0 -
DOUBLE - 8 - - - - DOUBLE - - -
FLOAT - 8 - - - - DOUBLE - - -
GRAPHIC - - - - - - GRAPHIC - - N
INTEGER - 4 - - - - INTEGER - - -
REAL - - - - - - REAL - - -
SMALLINT - 2 - - - - SMALLINT - - -
TIME - 3 - - - - TIME - - -
TIMESTAMP(p) - - p p - - TIMESTAMP(p) - p3 -
VARBINARY - - - - Y - VARBINARY - - Y
VARCHAR - - - - - - VARCHAR - - N
- - - - Y - VARCHAR - - Y
VARGRAPH - - - - - - VARGRAPHIC - - N
VARGRAPHIC - - - - - - VARGRAPHIC - - -
Note:
  1. If the date_compat parameter is set to OFF, the federated DATE maps to TIMESTAMP(0); otherwise, it maps to DATE.
  2. Operations are pushed down to the remote data source only if the SAME_DECFLT_ROUNDING server option is set to Y.
  3. For Version 9.5 or earlier, the remote scale for TIMESTAMP is 6.