This section contains procedures, commonly referred to as PROCs that can be used to group mapping and transformation logic into what are traditionally called Mapping Procs. This facilitates re-use of procedures both within and between Apply Engine instances. The CALLPROC function is used to execute a PROC from within the main processing section or another procedure.
Connect CDC (SQData) PROCs can be used to:
- Isolate mapping and mapping functions into separate modules for easier maintenance. These PROCs are then included in the main Apply Engine script with the #INCLUDE Parser directive.
- Create common ‘utility routines’ used by multiple Apply Engine scripts. For example, a common date routine that can be used by multiple application Engines.
- Improve the readability and maintainability of Apply Engine scripts that processing source datastores containing many different record types. This is commonly done when processing IMS and Relational changed data capture a single Apply Engine is used to process many different types of records from one or more source databases.
A second type of procedure expands upon the simple called PROC by supporting parameters when the PROC is called. Referred to as a User Function or Function PROC, the syntax is nearly identical but the result can be much more powerful since the variables inside the PROC are independent of the calling procedure enabling the creation of powerful User Functions.