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.
