Re: BEGIN WORK/COMIT WORK in stored procedure

Posted in 1996

David I. Berg — 30 Apr 1996 22:06:45 GMT — source: Informix-list mailing list archive (1991-1998)

Frank Bonk (bonk@positron.med.ge.com) wrote: : Can a transaction be defined in a stored procedure. : Something like - : CREATE PROCEDURE a() : FOR EACH : BEGIN WORK : INSERT...... : <more stuff> : COMMIT WORK : END FOREACH; : END PROCEDURE; Indeed! The only caveat is that the procedure may not be used in a triggered action because triggered actions may not delimit transactions. - David : Thanks for any help... : Frank -- ___ ___ Principal Consultant / ) __ . __/ /_ ) _ _ __ Informix Software Inc. (303) 850-0210 _/__/ (_(_ (/ / (_(_ _/__) (-' ~/ '(_- 5299 DTC Blvd #740 Englewood CO 80111 dberg@informix.com Opinions expressed herein are my own. Eventually all things merge into one...and a river runs through it. -N.Maclean