Add an external trigger

To add an external trigger to a table:

  1. In the System i Navigator window, expand the system you want to use.
  2. Expand Databases.
  3. Expand the database and schema that contains the table to which you want to add the trigger.
  4. Click the Tables container.
  5. Right-click the table to which you want to add the external trigger and select New -> Trigger -> External.

Notes:

The trigger program must exist before you can add it as an external trigger. If you are adding a trigger on a pre-V5R1 system, you can only specify the program name and schema on the General tab and the timing and operation on the Event tab. In addition, on pre-V5R1 system, you can only add one trigger for each event and time combination (in other words, a maximum of six triggers to a table.
Use caution when adding read triggers. Read triggers can cause your system performance to degrade.