The Environment section of the script contain Commands that specify global runtime parameters that are used during the execution of the Engine:
- JOBNAME – The unique name given to an Apply Engine. This name appears in both the Parser report and the Engine runtime report. The JOBNAME command normally specifies the "Subscriber name" passed by the Apply Engine when requesting connection to a Capture/Publisher. A Substitution parameter such as %(ENGINE) is typically used to supply the value when the script is parsed.
- OPTIONS - Global script processing options
- RDBMS - Supplies the connection information for a single relational database (RDBMS). This command must be used when the source or target datastore is a relational database. The RDBMS command must appear before a datastore referencing that database is defined.
- REPORT – Specifies the number of records/messages to process before writing an interim set of statistics to the Engine runtime report file. This is information can be useful for tracking the progress when processing a large number of source records.
- COMMIT – While this command specifies the number of records/messages to process before a commit is issued its use is not recommended when processing CDC data. CDC data is processed by unit-of-work (UOW) and a commit will automatically be performed when the entire UOW has been processed by the Apply Engine. This command can only be used when applying to datastores that support commit and rollback operations such as a database management system or IBM MQ.