Send and Receive Table Properties, Delete Condition tab - Connect_CDC - connect_cdc_mimix_share - 6.x

Connect CDC Getting Started Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
6.x
Language
English
Product name
Connect CDC
Title
Connect CDC Getting Started Guide
Copyright
2024
First publish date
2003
Last updated
2024-10-15
Published on
2024-10-15T20:38:41.117981

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

Note: If Journal target mapping is enabled on the Mapping tab of the Sending Table Properties dialog, you cannot configure a Delete Condition.

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.

  1. On the Delete Condition tab in either the Receiving or Sending Table Properties dialog, enter the SQL DELETE statement.

  2. Click Validate to verify that the statement is valid.

  3. Click OK.