RE: Triggers

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
MKirkpatrick@xxxxxxxxxxxxxxxxx
Sent: Thursday, August 23, 2007 10:43 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Triggers

I have a PF where when a certain field is changed I wish to write a copy

of the record to another file. Obviously, I could do this in the RPG
pgm
but prefer to not change the pgm.

I have been reading about triggers and would like some confirmation on a

couple things.

First, there are two kinds of DB triggers, PF and SQL table triggers.
I am not sure on this one.

Second, the PF trigger cannot detect an update to a specific field,
while
the SQL trigger can execute when a change in a specific column is
detected.
The PF trigger fires when the record is changed, this is if you do add a
change trigger, not an add or delete trigger. In a change trigger, you
get the before and after image of the record so you can check your field
and perform the action you need. Since you only want to record the
change, I would do an *AFTER *CHANGE trigger.

Third, since my file is a PF and not an SQL table, I cannot use the SQL
trigger and must use the ADDPFTRG.
I know nothing of the SQL trigger but the ADDPFTRG will work.

Fourth, if I were to change my PF to an SQL table, an SQL trigger would
be
a good choice to address my issue.
No need to be changing any files.

Any other suggestions as to how to handle my situation are also welcome.