Chapter 3. DB2 Information Integration architecture overview 53
wrappers. DB2 Information Integrator supplies a set of default data type
mappings such as the following:
• Oracle type FLOAT maps by default to the DB2 type DOUBLE.
• Oracle type DATE maps by default to the DB2 type TIMESTAMP.
• DB2 UDB for z/OS type DATE maps by default to the DB2 type DATE.
If you want to customize the default mapping provided by DB2 II, then you
need to create alternative data type mappings.
In order to use an alternative data type mapping for a nickname, you must
create this mapping prior to creating the nickname. If you create the
nickname first, you may set the appropriate mapping later as follows:
• Altering the nickname
• Changing default mapping types and ...