Stop Processing When Data Anomalies are Encountered
This example uses ABORT
to stop Replicat immediately with a fatal error if an anomaly is detected in a bank record, where the customer withdraws more money than the account contains. In this case, the source table is mapped to a target table in a Replicat MAP
statement for actual replication to the target. A TABLE
statement is also used for the source table, so that the ABORT
action stops Replicat before it applies the anomaly to the target database. ABORT
takes precedence over processing the record.
MAP source.account, TARGET target.account;
TABLE source.account, FILTER (withdrawal > balance), EVENTACTIONS (ABORT);