• Subject: Commit in Trigger process
  • From: "Weatherly, Howard" <hweatherly@xxxxxxxxxxxx>
  • Date: Tue, 12 Sep 2000 11:37:40 -0400

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



<<Weatherly, Howard.vcf>>

Weatherly, Howard.vcf

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.