Among the uses are generating events and inserting records in tables.
Written by Mohankumar Saraswatipura
Editor's note: This article is an excerpt from the book DB2 10.1/10.5 for Linux, UNIX, and Windows Database Administration (Exams 611 and 311): Certification Study Guide.
In DB2 10.1, you can create a multiple-event trigger to fire off a trigger action based on one of three possible triggering events—an INSERT, an UPDATE, or a DELETE statement—instead of creating a separate trigger for each event.
Multiple-event triggers are supported for both row-level triggers (FOR EACH ROW) and statement-level triggers (FOR EACH STATEMENT), which allows you to transform a complex business rule into sophisticated trigger logic. It also helps you greatly during the database migration process to migrate other database vendor products to DB2.