How to prevent/filter DML (Insert, update, delete) from replicating on a table. (4297109)

How to prevent/filter DML (Insert, update, delete) from replicating on a table.

At times it is required to ignore a DML, particularly DELETEs. Shareplex allows this control at table level and DML level.

General information.

Edit Resolution

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.