Please enable JavaScript to view this site.

The CLEAR_RECORD function preforms two useful operations:

1.Set all fields/columns of the specified record to NULL eliminating the need for individual initialization of potentially a large number of items.

2.Resets all field/column level mapping indicators. These indicators facilitate manually mapping or populating the value of individual fields/columns once.  The AUTOMAP and REPLICATE functions can then be used to populate the remaining target fields/columns automatically, skipping those manually mapped and significantly reducing the complexity of the Apply Engine script while at the same time raising performance.

Category

Changed Data Capture

Syntax

CDCUOW(<source_datastore>)

CLEAR_RECORD(TARGET, T_SHNLMAVR)

 

Parameter Descriptions

source_datastore  -  The name of the source datastore that contains the changed data capture (CDC) records.

Example

Retrieve the unit-of-work identifier from the current record in the source changed data capture (CDC) datastore CDCIN. Map the result to target field SRC_UOWID.

SRC_UOWID = CDCUOW (CDCIN)