Assign constants - 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-12-13
Published on
2024-12-13T13:15:51.808737

The INITIALIZE command is used to assign constant values to target fields. Although you can assign constants to target fields using the STRING function in a mapping procedure, the INITIALIZE command is more efficient, since this initialization is performed only once, where as the STRING function is invoked for each target record written.

Note: if the INITIALIZE command is issued for a group item field, all its children are initialized.

Example

Assigning a constant to target fields using the INITIALIZE command is provided below.

INITIALIZE TARGET_FIELD1 ‘AAA’;

INITIALIZE TARGET_FIELD2 ‘BBB’;

INITIALIZE GROUP_ITEM1 ‘CCC’;