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.

A trigger is a set of actions that run automatically when a specified change operation is performed on a specified database file. In this discussion, a table is a physical file. The change or read operation can be an insert, update, or delete high-level language statement in an application program, or an SQL INSERT, UPDATE, or DELETE statement.

To add a trigger, follow these steps:

1. From iSeries Navigator, expand your system > Database > Schemas.

2. Click the library that contains the table to which you want to add the trigger.

3. Right-click the table to which you want to add the trigger and click New > Trigger.

4. Click External to add a system trigger.

5. Click SQL to add an SQL trigger.

Parent topic:

Related concepts
Triggering automatic events in your database SQL triggers