IBM InfoSphere Federation Server, Version 10.5

Default forward data type mappings for DB2 Database for Linux, UNIX, and Windows data sources

The following table lists the default forward data type mappings for DB2® Database for Linux, UNIX, and Windows data sources.

Table 1. DB2 Database for Linux, UNIX, and Windows 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 -
BLOB - - - - - - BLOB - - -
CHAR - - - - - - CHAR - 0 N
CHAR - - - - Y - CHAR - 0 Y
CLOB - - - - - - CLOB - - -
DATE - - - - - - DATE - 0 -
DATE - - - - - - TIMESTAMP1 - 0 -
DBCLOB - - - - - - DBCLOB - - -
DECIMAL - - - - - - DECIMAL - - -
DECFLOAT 2 - - - - - - DECFLOAT - 0 -
DOUBLE - - - - - - DOUBLE - - -
FLOAT - - - - - - DOUBLE - - -
GRAPHIC - - - - - - GRAPHIC - 0 N
INTEGER - - - - - - INTEGER - 0 -
LONGVAR - - - - N - CLOB - - -
LONGVAR - - - - Y - BLOB - - -
LONGVARG - - - - - - DBCLOB - - -
REAL - - - - - - REAL - - -
SMALLINT - - - - - - SMALLINT - 0 -
TIME - - - - - - TIME - 0 -
TIMESTAMP(p) - - p p - - TIMESTAMP(p) - p -
VARCHAR - - - - - - VARCHAR - 0 N
VARCHAR - - - - Y - VARCHAR - 0 Y
VARGRAPH - - - - - - VARGRAPHIC - 0 N
VARGRAPHIC - - - - - - VARGRAPHIC - 0 N
Note:
  1. The federated type is TIMESTAMP(0) if the date_compat configuration parameter is set to ON.
  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.
Parent topic: Default forward data type mappings

Feedback