INITIALIZE - connect_cdc_sqdata - Latest

The INITIALIZE command initializes a target field/column to a constant value. This has a performance advantage over mapping string constants to a target field, since it is performed only one time.

Once the value of a target field has been set with the INITIALIZE command, it can subsequently be mapped later by functions within the Apply Engine script.

INITIALIZE [<target_datastore>][.<target_description>].<target_field> <value>;

Example 1:

INITIALIZE target_field1     '501';

Example 2:

INITIALIZE   target_ds.target_descr.target_field1   '501';

Example 3:

INITIALIZE   target_field1   &ZEROS;

Example 4:

INITIALIZE   target_field1   &&SPACES;