Table 6.1 shows the summary of event
processing options.
|
Apply Handler |
Event Type |
Default Apply Behavior |
Scope |
|
DML or Error Handler |
Row LCR |
Execute DML |
One operation on one table |
|
DDL Handler |
DDL LCR |
Execute DDL |
Entire Apply process |
|
Precommit Handler |
Commit Directive (Row LCR and Non-LCR
User message) |
Commit transactions |
Entire Apply process |
|
Message Handler |
Non-LCR User message |
Creates error, if no handler is
specified |
Entire Apply process |
Table 6.1 Summary of event processing
options
DML and the Error Handler process row LCRs
and execute the DML transactions. DML handlers act on a table
and are specific to an SQL operation. If the SQL operation such
as Delete, Update or Insert is not specified, the handler is
applicable to all the operations on the table.
