I am having trouble with a trigger program that updates a file. The program is triggered when a transaction file is updated and is used to update the master file the transaction file is associated with. Problem is, the program that orinally adds the master record and then the first transaction record runs under commitment control. Thus, when the trigger program fires, the record it tries to update is locked due to committment control still being active. Does anyone know a way to get around this?????
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Using a trigger program to update a file under commit control
- Thread starter RDycus
- Start date
Similar threads
- Locked
- Question