CLEAR_RECORD - connect_cdc_sqdata - Latest

Connect CDC (SQData) Apply engine

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Apply engine
Copyright
2024
First publish date
2000
Last updated
2024-10-14
Published on
2024-10-14T17:43:00.004977
The CLEAR_RECORD function performs two operations:
  • Sets all fields/columns of the specified record to NULL eliminating the need for individual initialization of potentially a large number of items.
  • 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

Change Data Capture

Syntax
CDCUOW(<source_datastore>)
CLEAR_RECORD(TARGET, T_SHNLMAVR)
Parameter and Description
Parameter Description
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)