Manta alt

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.