Course Description: 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.
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
Audience: This course is intended for programmers and application developers who will be creating trigger programs.
Prerequisites: This course assumes that you have a basic knowledge of OS/400 facilities. You can satisfy this prerequisite by successfully completing the Using an iSeries System series. It also assumes that you have a basic knowledge of DB2 UDB. You can satisfy this prerequisite by successfully completing the first course in the series, Introduction to DB2 UDB. Finally, it assumes you have a reading knowledge of either RPG IV or COBOL.
Course Outline: Introduction to Triggers Coding a Trigger Program CL Commands for Working with Triggers Trigger Program Design and Performance Considerations
Course Details:
Length:
2 hours
Materials:
A Student Reference Guide is available for this series.
Using Triggers
