Articles & Content

Archives

E02 - What I Could Have Used Instead of Triggers

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2015



Instead of Triggers were introduced in DB2 V9 in March 2007, so although this topic is not at the bleeding edge, there are a few "gotchas" to be aware of.

An Instead of Trigger is a trigger that is associated with a single view and is activated by an insert, update, or delete operation on the view and that can define how to propagate
the insert, update, or delete operation on the view to the underlying tables of the view.

In this presentation I will discuss how I used the feature to incorporate some business logic.

I'll discuss the issues that I encountered with creation of the objects and a V10 migration issue that I encountered.

I'll then explore the alternatives available.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.