Re: Simple Trigger Program

["Paul Tuohy" <tuohyp@xxxxxxxxxxxxx>]

Hi Bob,

As of V5R3 (I think) you can define an SQL trigger at the column level.

If you use iSeries Navigator, expand the Databases option to the required
Schema and, from the context menu of the Triggers option select New->SQL.
You will see that you have an option for "Update of selected columns".

The downside (?) is that the trigger has to be an SQL script.

External triggers (RPG, CL etc.) cal only be specified for the record level.

HTH

Paul Tuohy

----- Original Message -----
From: "Bob O." <otis_the_cat@xxxxxxxxxxx>
To: <midrange-l@xxxxxxxxxxxx>
Sent: Tuesday, June 21, 2005 3:30 PM
Subject: Simple Trigger Program


>    Is it possible to define a physical file trigger to fire when a
specific
>    field is changed, or is it only possible to detect the changed record.
We
>    don't have any triggers on our files (it was like that when I got
here!),
>    and I finally came across a reason to use one (hence my very first
trigger
>    program).
> --