Commit in Trigger process

["Weatherly, Howard" <hweatherly@xxxxxxxxxxxx>]

Title: Commit in Trigger process

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?

The first thing the DRDA program does is:
        Exec SQL RELEASE ALL SQL End-Exec
        Exec SQL COMMIT End-Exec        
        Exec SQL DISCONNECT ALL End-Exec

Prior to this the trigger program simply gets the data from the trigger buffer and decides what DRDA program to call.

Howard Weatherly

(616)961-4324

hweatherly@dlis.dla.mil        
howard.weatherly@ctg.com

<<Weatherly, Howard.vcf>>

Weatherly, Howard.vcf