Before you start
This series of six DB2 SQL Procedure Developer tutorials covers all the basic constructs and methods of the SQL Procedural Language and shows how it can be used in stored procedures, user-defined functions, and triggers, including error handling and deployment. It also covers some DB2 9.5 advanced features like optimistic locking, hierarchical queries, and declared global temporary tables. This series provides specifics on how stored procedures, user-defined functions, and triggers can be invoked, and how you can share data between procedures and functions. It introduces DB2 development tools, including IBM Data Studio. These tutorials provide a solid base for each section of the exam. However, you should not rely on these tutorials as your only preparation for the exam. More exam resources can be found in the Resources section of this tutorial.
In this tutorial, get an introduction to the concepts of identifying trigger usage, trigger types, creating a trigger and its required privileges, and associated trigger actions.
After completing this tutorial, you should :
- Be able to identify proper usage of triggers
- Understand trigger types
- Understand the required privileges for creating a trigger
- Know how to create a trigger
- Be able to create, deploy and identify trigger actions
- Be familiar with advanced uses for triggers
To take the DB2 9.5 SQL Procedure Developer exam, you must have already passed the DB2 9 Family Fundamentals exam (Exam 730). You can use the DB2 9 Fundamentals certification 730 prep series to prepare for that exam. It is a very popular series that has helped many people understand the fundamentals of the DB2 family of products.
This tutorial is written for DB2 programmers whose skills and experience are at an introductory to intermediate level. You should have a general background knowledge of how a relational database works as well as basic knowledge of databases, database programming constructs, and operating system security. You should also be familiar with using the DB2 Command Line Processor (CLP), and you should have a working knowledge of SQL.
To run the examples in this tutorial, you need access to a DB2 9.5
database server and the SAMPLE database that is provided with DB2.
(The SAMPLE database can be created by executing the command
db2sampl from the DB2 Command Line