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.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.