RE: Triggers and Commitment Control

Thanks for the reply. 

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Wilt, Charles
Sent: Wednesday, January 17, 2007 10:12 AM
To: Midrange Systems Technical Discussion
Subject: RE: Triggers and Commitment Control

Jack,

If the files with the triggers use commitment control, then the triggers
should also use commitment control.

That being the case, then your answer is 

3. When the uncommitted write is done to the triggering file.  Any
writes done by the trigger are committed/rolled-back when the triggering
files changes are committed/rolled-back.

HTH,

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx 
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of derhamj
Sent: Wednesday, January 17, 2007 8:21 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Triggers and Commitment Control

Hi List:

 

My question today: When running under commitment control and 
using files
that have triggers assigned and enabled, when to the triggers 
actually fire?

 

The two possibilities as I see then are:

1.       when the logical write is done (program flow)

2.       when the actual commitment write is done 

 

Responses from experience would be appreciated.

 

Jack Derham

Direct Systems, Inc.

 

--

-- 
This is the Midrange Systems Technical Discussion 
(MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.