Custom Retention Rules: This menu item allows you to maintain the custom data retention rules used on specific tables. These rules are applicable in Pro2 for tasks like Bulk-Load, Bulk-ASCII-Export, Verification, and Replication. An IF statement is used to exclude Data that satisfies the condition. To set custom retention rules, perform the following steps:
  1. Click Add to open the Add a new custom retention rule window

  2. Select the Source DB and the respective Source Table
  3. Choose the rule Type to specify a new Custom Retention rule
  4. Add a condition statement
  5. Click Save
Note: After adding or modifying a Custom Retention Rule, you must regenerate the bulk-load and replication process library code for the changes to take effect. Once the process libraries are regenerated, the replication thread associated with the respective table must also be restarted.