Return
-
Title
How to prevent/filter DML (Insert, update, delete) from replicating on a table. -
Description
At times it is required to ignore a DML, particularly DELETEs. Shareplex allows this control at table level and DML level.
-
Cause
General information. -
Resolution
Edit ResolutionIn replication environments, there can be a need to control whether, for instance, DELETES are replicated for a specific table. The DML filtering syntax for the configuration file was implemented to address this need.
The DML filtering syntax within the configuration file allows the user to specify for a table those DML that should NOT be replicated. To specify a DML filter, the following syntax must follow the source table specification:
!dml()
The DML are indicated as follows:
d DELETE
i INSERT
u UPDATE
For example, here is a configuration entry for a table with DELETES filtered out:
scott.emp !dml(d) scott.emp prodsys@o.sysdb
Create the config file as above and activate it to have the DML filtering enabled.
-
Additional Information
More than one DML can be filtered out. The following configuration line would replicate ONLY updates: scott.stock !dml(d,i) scott.stock prodsys@o.sysdb Note that the DML filter syntax will work with any other configuration syntax such as Wildcard specifications Vertical partitioning Horizontal Partitioning CDC Open target User key Also note the following exceptions: • SharePlex will fail a copy or compare of a table with DML filtering • Activation will not allow a table to be specified twice in a configuration file where the DML filtering definition does not match Note: This article applies to SharePlex version 8.0 and above. Also note the following exceptions: • SharePlex will fail a copy or compare of a table with DML filtering • Activation will not allow a table to be specified twice in a configuration file where the DML filtering definition does not match Note: This article applies to SharePlex version 8.0 and above.