turn on AutoCommit

Posted in 2000

Thomas.Brixel — Fri, 19 May 2000 13:18:21 +0200 — source: Informix-list mailing list archive (1991-1998)

Hi all, how can I turn on AutoCommit after I did a BEGIN WORK or the database is ANSI (AutoCommit turned off by default)? TIA Thomas -------------------------------------------------- * Alternative E-Mail Addressen: * Thomas.Brixel@arcormail.de * Thomas.Brixel@gmx.de * Thomas.Brixel@informatik.fh-fulda.de --------------------------------------------------

↪ replying to Thomas.Brixel

Art S. Kagel — Fri, 19 May 2000 14:33:40 -0400 — source: Informix-list mailing list archive (1991-1998)

There is no AutoCommit. You MUST either COMMIT or ROLLBACK WORK in ANY logged database, Informix or ANSI mode. Art S. Kagel "Thomas.Brixel" wrote: > > Hi all, > > how can I turn on AutoCommit after I did a BEGIN WORK or the database is > ANSI (AutoCommit turned off by default)? > > TIA > > Thomas > > -------------------------------------------------- > * Alternative E-Mail Addressen: > * Thomas.Brixel@arcormail.de > * Thomas.Brixel@gmx.de > * Thomas.Brixel@informatik.fh-fulda.de > --------------------------------------------------

↪ replying to Art S. Kagel

Jonathan Leffler — Sat, 20 May 2000 05:48:44 GMT — source: Informix-list mailing list archive (1991-1998)

"Art S. Kagel" wrote: > There is no AutoCommit. You MUST either COMMIT or ROLLBACK WORK in ANY > logged database, Informix or ANSI mode. > > "Thomas.Brixel" wrote: > > how can I turn on AutoCommit after I did a BEGIN WORK or the database is > > ANSI (AutoCommit turned off by default)? In the non-ODBC world, Art is technically correct - there is no AutoCommit. ODBC has AutoCommit as an attribute, so I assume the Informix ODBC drivers support/emulate it. However, you get the same net result as AutoCommit On once you do COMMIT or ROLLBACK in a regular logged database. There's no non-programmatic way of simulating AutoCommit in a MODE ANSI database. Yes, I do know about this -- DBD::Informix has to handle AutoCommit and it is a complete PITA. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v1.00.PC1 -- see http://www.perl.com/CPAN #include <disclaimer.h> PITA: The A stands for 'posterior'.

↪ replying to Jonathan Leffler

Thomas.Brixel — Mon, 22 May 2000 09:36:54 +0200 — source: Informix-list mailing list archive (1991-1998)

Jonathan Leffler wrote: > > "Art S. Kagel" wrote: > > > There is no AutoCommit. You MUST either COMMIT or ROLLBACK WORK in ANY > > logged database, Informix or ANSI mode. > > > > "Thomas.Brixel" wrote: > > > how can I turn on AutoCommit after I did a BEGIN WORK or the database is > > > ANSI (AutoCommit turned off by default)? > > In the non-ODBC world, Art is technically correct - there is > no AutoCommit. ODBC has AutoCommit as an attribute, so I assume > the Informix ODBC drivers support/emulate it. > > However, you get the same net result as AutoCommit On once you > do COMMIT or ROLLBACK in a regular logged database. > > There's no non-programmatic way of simulating AutoCommit in a > MODE ANSI database. > > Yes, I do know about this -- DBD::Informix has to handle AutoCommit > and it is a complete PITA. I didn't use the ODBC driver, but JDBC which is implemented following the ODBC design. JDBC also allows to set AutoCommit ON. I testet it because I could hardly believe it, and it works. Thank you both for your help. Thomas -------------------------------------------------- * Alternative E-Mail Addressen: * Thomas.Brixel@arcormail.de * Thomas.Brixel@gmx.de * Thomas.Brixel@informatik.fh-fulda.de --------------------------------------------------