Commit

Posted in 2000

Sonia Gillespie — Tue, 26 Sep 2000 12:04:54 +0100 — source: Informix-list mailing list archive (1991-1998)

Is there a mechanism that Informix uses by which to automatically commit any transactions that take place on the database? If there are a number of stored procedures on the database that don't contain commit statements, how could they get committed on the database? Thanks in advance, -- Sonia Gillespie E-mail: sonia_gillespie@lagan.com

↪ replying to Sonia Gillespie

Surfer! — Tue, 26 Sep 2000 13:27:07 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <969966374.29283.0.nnrp-08.9e9859ae@news.demon.co.uk>, Sonia Gillespie <sonia_gillespie@lagan.com> writes >Is there a mechanism that Informix uses by which to automatically commit any >transactions that take place on the database? > >If there are a number of stored procedures on the database that don't >contain commit statements, how could they get committed on the database? If they are committed within another transaction. It will also commit changes when a program exits unless you are correctly using 'BEGIN WORK' and 'COMMIT WORK' or 'ROLLBACK WORK'. > >Thanks in advance, > >-- >Sonia Gillespie >E-mail: sonia_gillespie@lagan.com > > -- Surfer!