YOUR IBM i TRAINING SOURCE

You must allow the browser to execute JavaScript programs if you want to view product information. If your browser is set up to execute JavaScript programs, the problem is that the product ID was incorrect. Use the menu bar above to find the desired product.

Overview

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

Objectives

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

Topic Outline

Introduction to Triggers

Coding a Trigger Program

CL Commands for Working with Triggers

Trigger Program Design and Performance Considerations

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 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.