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

print  |  top of page