This course describes how to code and use trigger programs.
The course begins by describing trigger program concepts and terminology. You will then see how to code a trigger program. Next, the course covers the CL commands related to triggers. You will see how to assign a trigger to a file, display information about the triggers assigned to a file, and remove a trigger. The course ends by discussing the design and performance issues that are unique to trigger programs.
Approximate Study Time: 2 hours
After completing this course, you should be able to:
- Describe the function and capabilities of a trigger program
- Identify the database events that can cause a trigger to fire
- Identify appropriate applications for a trigger
- Identify the different types of triggers that can be assigned to a file
- Describe the general format of the trigger buffer and the information it contains
- Describe and use common trigger program coding techniques
- Assign a trigger to a file
- Display information about the triggers that have been assigned to a file
- Remove a trigger from a file
- Define what is meant by cascading triggers and recursive trigger firing
- Identify situations in which a multiple-purpose trigger program is appropriate
- Describe the techniques that can be used to limit user access to trigger programs
- Identify the issues related to error handling in a trigger program
- Describe the effects of using commitment control with a trigger program
- List the processing limitations of a trigger program
Introduction to Triggers
Coding a Trigger Program
CL Commands for Working with Triggers
Trigger Program Design and Performance Considerations
This course is intended for programmers and application developers who will be creating trigger programs.
This course assumes that you have a basic knowledge of IBM i facilities. You can satisfy this prerequisite by successfully completing the Introduction to the IBM i Environment series. It also assumes that you have a basic knowledge of DB2. You can satisfy this prerequisite by successfully completing the first course in the series, Introduction to DB2. Finally, it assumes you have a reading knowledge of either RPG IV or COBOL.