Creating trigger programs

You can create and work with a program that contains a set of trigger actions.

To add a trigger to a database file, follow these steps:

1. Supply a trigger program. You can write a trigger program in a high-level language (HLL), Structured Query Language (SQL), or control language (CL).

2. Use one of the following methods to add the trigger:

   • The Add Physical File Trigger (ADDPFTRG) command. You must specify your trigger program in the trigger program (PGM) parameter on the command.

   • Add a trigger using iSeries™ Navigator.

   • The CREATE TRIGGER SQL statement.

• Adding triggers using iSeries Navigator
  Using iSeries Navigator, you can define system triggers and SQL triggers. Additionally, you can enable or disable a trigger on a physical database file.

• How trigger programs work
  When a user or an application issues a change or read operation on a database file that has an associated trigger, the operation calls the appropriate trigger program or programs.

• Other important information about working with trigger programs
  Here are the recommendations, precautions, and error messages for trigger programs. Information about monitoring and commitment control is also included.

• Examples: Trigger programs
  These example trigger programs are triggered by write, update, and delete operations on the ATMTRANS file. They are written in ILE C, ILE COBOL, and RPG/400^®.

• Trigger buffer sections
  The trigger buffer has two logical sections: a static section and a variable section.

Parent topic: