Revision history [back]

The DB2 Trigger can do various tasks following an insertion, some of which are:

1. Modify data in other tables: A DB2 trigger can be set up to modify data in other tables following an insertion in the main table.

2. Perform additional checks: A DB2 trigger can be set up to perform additional checks on the data being inserted to ensure data integrity.

3. Notify users: A DB2 trigger can be set up to send notifications to users or other systems following an insertion.

4. Update view: A DB2 trigger can be set up to update a view whenever data is inserted into the table.

5. Maintain audit trail: A DB2 trigger can be set up to maintain an audit trail of all insertions made to the table.

6. Assign default values: A DB2 trigger can be set up to assign default values to certain fields whenever data is inserted into the table.

7. Block insertion: A DB2 trigger can be set up to block the insertion of certain data into the table based on predefined criteria.