Re: Commit in Trigger process

[Pete Hall <pbhall@xxxxxxxxxx>]

At 10:37 09/12/2000 , Howard Weatherly wrote:

>We have a process that updates files on the AS/400 and when completed 
>inserts a row into a table that initiates a trigger. The trigger program 
>calls a DRDA program that synchronizes the mainframe data with the AS/400.
>
>My question are:
>When should the program on the AS/400 issue a commit? before inserting to 
>the trigger table or after?
>Should the trigger program issue a commit to ensure that all upstream 
>processing is cleaned up?
Trigger programs are not intended to execute commit or rollback. I think it 
might even be invalid to issue a commit in a trigger, but I'm not certain. 
The intent is that a trigger should adopt the same commit level as the 
initiating process. That process is responsible for committing changes. I 
don't know how that fits in with DRDA though. Does it handle two phase commits?


Pete Hall
pbhall@execpc.com
http://www.execpc.com/~pbhall/
+---
| 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
+---