Configure a standard function as table-level user exits for the CDC Replication Engine for Db2 for i (version 6.2 and earlier) or the CDC Replication Engine for Db2 for z/OS

You can configure table-level user exits for the CDC Replication Engine for Db2® for i (version 6.2 and earlier) or the CDC Replication Engine for Db2 for z/OS® by writing standard function user exits in RPG, COBOL or C/C++.

Procedure

  1. Ensure that you are connected to an he CDC Replication Engine for Db2 for i or the CDC Replication Engine for Db2 for z/OS datastore.
  2. Click Configuration > Subscriptions.
  3. Select the subscription.
  4. Click the Table Mappings view and select the table mapping from the Source Table column.
  5. Right-click and select Open Details....
  6. Click the User Exits tab.
  7. Select Standard Function from the User Exit Type list.
  8. Enter the name of the user exit programs you want CDC Replication to call beside one or more of the following operations:
    Before Insert
    CDC Replication runs the user exit before replicating an insert operation.
    After Insert
    CDC Replication runs the user exit after replicating an insert operation.
    Before Update
    CDC Replication runs the user exit before replicating an update operation.
    After Update
    CDC Replication runs the user exit after replicating an update operation.
    Before Delete
    CDC Replication runs the user exit before replicating a delete operation.
    After Delete
    CDC Replication runs the user exit after replicating a delete operation.
    Before Refresh
    CDC Replication runs the user exit before replicating a refresh operation.
    After Refresh
    CDC Replication runs the user exit after replicating a refresh operation.
    Before Truncate
    CDC Replication runs the user exit before replicating a truncate operation.
    After Truncate
    CDC Replication runs the exist after replicating a truncate operation.
  9. Click Save.