TargetColumn
The TargetColumn (TC) parameter lets you specify a column name in the target table that differs from the column name in the source table. Specifying the TargetColumn parameter with a corresponding SourceColumn parameter defines how the High-speed Apply Engine maps the column name for the apply request. You can specify this parameter as many times as necessary to map the columns defined with the SourceColumn parameter.
Attributes
This parameter has the following attributes:
Attribute | Value |
---|---|
Section | [ObjectMap] |
Abbreviation | TC |
DBMS | Db2, Db2 LUW, Oracle |
Required? | No |
Valid values | A valid column name from the target table |
Default value | None |
Usage
If you specify TargetColumn, the SourceColumn parameter must immediately precede it. You can include wildcard characters as part of the column name. For more information about using wildcard characters in object-name mapping, see Using-wildcards-to-map-object-names.
This parameter is not valid if your input contains data definition language (DDL) statements in SQL input or DDL objects (in logical log input).
Related topic