Re: Triggers and Commitment Control

[Pete Hall <peteh@xxxxxxxxxx>]

At 14:05 09/02/98 -0500, Bradley V. Stone wrote:
>Quick question.
>
>If I'm using commitment control on a file that has a trigger attached to
>it on the *ADD *AFTER option, when does the trigger fire?  On the WRITE
>or on the COMMIT?  If I Rollback, is the trigger fired?

Brad,

It fires on the WRITE. IBM recommends that commitment control for files updated 
by a trigger should be the same as the file to which the trigger is attached. 
When the job executes a commit, the trigger's changes are committed also. BTW, 
they also recommend that commit and rollback never be performed by the trigger 
itself.

Pete Hall
peteh@inwave.com 
http://www.inwave.com/~peteh/

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---