Re: Simple Trigger Program

["Paul Tuohy" <tuohyp@xxxxxxxxxxxxx>]

Actually, I think it is V5R1 that column triggers were introduced. Also,
AFAIK, SQL triggers require the SQL developemnt Kit.

HTH

Paul Tuohy

----- Original Message -----
From: "Paul Tuohy" <tuohyp@xxxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Wednesday, June 22, 2005 9:45 AM
Subject: Re: Simple Trigger Program


> 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).
> > --
>