ObjectMap parameters

The [ObjectMap] parameters let you specify target table and column names that differ from the source table and column names.

For each target table that has a different definition than your source table, you must specify a set of [ObjectMap] parameters. If you do not include an [ObjectMap] section, the High-speed Apply Engine uses the source object names as the target names.

Parameter

Reference

SourceColumn (SC)

SourceTable (ST)

TargetColumn (TC)

TargetTable (TT)

Related topics

Command-and-syntax-reference

Format-of-configuration-parameters

Configurations-for-specific-tasks

The following figure shows an example of the [ObjectMap] parameters values. Example of [ObjectMap] parameters (column only) shows how to change the name of a column without changing the name of the table that contains the column.

To specify object mapping parameters for Db2 objects with long names, you might need to use multiple lines in your configuration file. For more information, see Overview of the configuration file’s format.

Important

Be aware of the following considerations when specifying [ObjectMap] parameters:

  • Do not specify [ObjectMap] parameters if your input contains data definition language (DDL) statements in SQL input (or DDL objects in logical log input). Due to processing constraints, High-speed Apply Engine does not support the combination of object mapping and DDL input.
  • A logical log file generated with overtime mode might contain multiple instances of the same object, (for example, a table that was dropped and then recreated). Therefore, you should not specify [ObjectMap] parameters for a table with multiple instances.

If you specify table names only, all columns are included and the target table columns are same as the source table columns. If all column names in target table are different from those in the source table, you must map all columns manually. If one column name is different in the target table from the source table, you have to specify only that column in object mapping. All other columns are still used and are assumed to have the same name on the source and the target tables.

Important

When you map column names except one or more, that one target column name becomes the default name as the source table. You cannot exclude a column from object mapping.


 [ObjectMap]
   SourceTable=ACCTG.EMPLYE
   TargetTable=SYS14.EMPLOY
   SourceColumn=NAME
   TargetColumn=EMPNAME
   SourceTable=ACCTG.PAYROLL
   TargetTable=SYS14.PAYROLL
   SourceColumn=SALARY
   TargetColumn=PAYRATE
 [ObjectMap]
   SourceTable=ACCTG.EMPLYE
   TargetTable=ACCTG.EMPLYE
   SourceColumn=NAME
   TargetColumn=EMPNAME


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*