 | Level: Intermediate Hareendranath Kattana , Enablement Consultant, IBM
James Merry (jmerry@us.ibm.com), Enablement Consultant, IBM
26 Feb 2009 Gain an understanding of the fundamental concepts behind
IBM® DB2® triggers — when, how, and what kind of triggers
can be used under various circumstances and the required user privileges. This tutorial is Part 4 of a
series
of tutorials designed to help you prepare for the IBM Certified Solution
Developer - DB2 9.5 SQL Procedure Developer exam (Exam 735).
Objectives - 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.
Prerequisites
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.
System requirements
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
Processor.)
Duration
Less than two hours
Formats html, pdf
About this series
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.
| | | |
