External triggers
For an external trigger, the program that contains the set of trigger actions can be defined in any supported high-level language that creates a *PGM object.
The trigger program can have SQL embedded in it. To define
an external trigger, you must create a trigger program and add it to a table
using the Add Physical File Trigger (ADDPFTRG) CL command or you can add it
using System i® Navigator. To add a
trigger to a table, you must do the following things:
- Identify the table.
- Identify the kind of operation.
- Identify the program that performs the actions that you want.