Default forward data type mappings for Db2 data sources

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

Table 1. Db2 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
BIGINT - - - - - - BIGINT - 0 -
BINARY - - - - Y - BINARY - - Y
BLOB - - - - - - BLOB - - -
BOOLEAN - - - - - - BOOLEAN - - -
CHAR - - - - - - CHAR - 0 N
- - - - Y - CHAR - 0 Y
CLOB - - - - - - CLOB - - -
DATE1 - - - - - - DATE - 0 -
- - - - -   TIMESTAMP(0) - 0 -
DBCLOB - - - - - - DBCLOB - - -
DECIMAL - - - - - - DECIMAL - - -
DECFLOAT 2 - - - - - - DECFLOAT - 0 -
DOUBLE - - - - - - DOUBLE - - -
FLOAT - - - - - - DOUBLE - - -
GRAPHIC - - - - - - GRAPHIC - 0 N
INTEGER - - - - - - INTEGER - 0 -
LONGVAR - - - - N - CLOB - - -
- - - - Y - BLOB - - -
LONGVARG - - - - - - DBCLOB - - -
REAL - - - - - - REAL - - -
SMALLINT - - - - - - SMALLINT - 0 -
TIME - - - - - - TIME - 0 -
TIMESTAMP(p) - - p p - - TIMESTAMP(p) - p -
VARBINARY - - - - Y - VARBINARY - - Y
VARCHAR - - - - - - VARCHAR - 0 N
- - - - Y - VARCHAR - 0 Y
VARGRAPH - - - - - - VARGRAPHIC - 0 N
VARGRAPHIC - - - - - - VARGRAPHIC - 0 N
Note:
  1. If the date_compat parameter is set to ON, the federated DATE maps to TIMESTAMP(0); otherwise, it maps to DATE.
  2. The SAME_DECFLT_ROUNDING server option is set to N by default and operations will not be pushed down to the remote data source unless SAME_DECFLT_ROUNDING is set to Y. For information on the SAME_DECFLT_ROUNDING server option, see DB2 database options reference.