RE: Commit

Posted in 2000

Don Ignacio — Tue, 26 Sep 2000 13:38:40 -0400 — source: Informix-list mailing list archive (1991-1998)

If your database is a non-ANSI database each DML statement is treated as one single transaction, thereby eliminating the need to call COMMIT. However, if you call BEGIN WORK before executing DML statements (provided of course that your database has logging enabled), you would need to explicitly call COMMIT (ROLLBACK) in order to end the transaction and save all changes, if applicable. Don -----Original Message----- From: Sonia Gillespie [mailto:sonia_gillespie@lagan.com] Sent: Tuesday, September 26, 2000 7:05 AM To: informix-list@iiug.org Subject: Commit 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