Optionally, use the Delete Condition tab in either the Receiving or Sending Table Properties dialog to create a custom SQL DELETE statement that is executed at the target server when:
-
A delete operation of a copy request is executed when Delete on target, refresh is enabled (see the Connect CDC Advanced User Guide for more information on Delete on target, refresh)
-
The truncate operation on an IBM i system, replicated from the source, is executed
This option enables you to specify what is deleted on the target table. For example, if you have a many-to-one mapping (multiple source tables mapped to one target table), you can create an SQL statement that only deletes a subset of the rows in the target table.
-
On the Delete Condition tab in either the Receiving or Sending Table Properties dialog, enter the SQL DELETE statement.
-
Click Validate to verify that the statement is valid.
-
Click OK.