Creating a DELETE trigger for a CDC change table
You can create only a DELETE trigger for a CDC change table using the Table Triggers option in the Data Dictionary.
To create a DELETE trigger:
1. In the Data Dictionary window, connect to the database that has the CDC change table.
The Data Dictionary lists all the CDC change tables defined for your database.
2. Select the CDC change table for which you want to create the DELETE trigger, and then click Table Properties.
The Table Properties window appears.
3. Click Triggers.
The Table Triggers window appears.
4. Select DELETE from the Event drop-down options.
5. Either click Files under the Procedure option to choose a .p file or write the procedure for DELETE.
6. Click OK.
