RE: Web application and a trigger

Judy,
 
The fact that it's a web app has no real bearing on how the commitment control 
will work. Provided the trigger is coded to update the file(s) using commitment 
control, it will be in the same commitment boundary, so a commit or rollback 
will effect the initial update and the updates from the trigger. HOWEVER, if 
the trigger submits a program to batch then that job will have it's own 
commitment boundary and will be uneffected by the commit/rollback of the 
original (submitting) job. 
 
As for how common it is to use commitment control this way, it's relatively 
common if you're talking about validation that occurs between screen updates. I 
have seen it used across screen updates (that is, a commitment boundary that 
holds uncommitted updates while the user enters data) but I don't like that 
approach at all. However, if you're talking about updates that occur and 
complete before the control is returned to the user, that's kind of what 
commitment control is for. You just do your updates as you see fit and if 
something goes wrong it's all undone for you. It's all part of ACID 
(http://en.wikipedia.org/wiki/ACID)
 
-Walden
 
--
Walden H Leverich III
Tech Software
(516) 627-3800 x3051
WaldenL@xxxxxxxxxxxxxxx <mailto:WaldenL@xxxxxxxxxxxxxxx> 
http://www.TechSoftInc.com <http://www.TechSoftInc.com> 
Quiquid latine dictum sit altum viditur. (Whatever is said in Latin seems 
profound.)