Connect CDC SQData

There are several distinct types of Apply Engine script commands. Some specify a behavior affecting the entire execution of an Engine instance or how specific types of data are transformed, others define data sources and targets, declare object references, specify the attributes of source data elements, define called procedures, provide access to external data and control the flow of the Engine's processing cycle.

Commands begin with a keyword and end with a semicolon (;). There are four command types:

•Environment Commands - Environment commands provide global runtime control such as commit scope and reporting.

•Data Definition Commands - Define datastores and cursors.

•Field Specification Commands - Define variables, alter field attributes, format dates, etc.

•Processing Commands - Control the processing of the target datastore(s).

This section describes each command in detail including their syntax, keyword and parameter descriptions. Examples are provided to illustrate the use of these commands in the heterogeneous environments typical of most implementation. While the examples are relatively simple they also illustrate the use of the naming conventions described previously.