Articles & Content

Archives

The 3 P's of Triggers - Performance, Pitfalls and PL/SQL

Topic: DB2 for z/OS

Subtopic: 2014



Triggers have now been with us since Version 6 of DB2 (1999!) so it is perhaps time for a refresher.
This presentation starts with a recap of the different types of trigger (including the new INSTEAD OF variety) before looking at how they are used.
We'll look at some performance aspects of triggers and understand why they should not be used indiscriminately.
Finally, we'll finish with some basic examples of triggers



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.