Home >
DB2 UDB for LUW >
DB2 Triggers
DB2 Triggers
| Course Code: |
DWUTRG |
| Currency: |
V8 & V9 |
| Duration: |
1 day |
| Audience: |
Application Developers, Application Programmers,
Production DBAs, Database Administrators and Capacity
Planners. |
| Prerequisites: |
Completion of our course DB2 SQL Essentials or
equivalent knowledge. |
| Summary: |
Among the topics covered in this course are:
- Creating triggers
- INSERT, UPDATE and DELETE triggers
- Trigger interactions with referential constraints
- INSTEAD OF triggers
- Trigger granularity
- Trigger activation time
- Transition variables & transition tables
- Triggered action
- Multiple triggers
- Synergy between triggers, constraints & routines
|