Re: NOT IN TRANSACTION

Posted in 1999

Sujit.Pal@BankAmerica.com — Thu, 06 May 1999 09:38:18 -0700 — source: Informix-list mailing list archive (1991-1998)

Jalal If you are the DBA (ie you can su informix), then from the command prompt, type: ontape -s -<LogLevelSwitch> <yourdatabasename> where LogLevelSwitch can be U (for unbuffered logging), B (for buffered logging) or A (for ANSI style logging). With U all transactions are immediately flushed to disk on COMMIT, while with B transactions are cached until a checkpoint. With A, each SQL statement will be an implicit transaction, and you dont need BEGIN/COMMIT WORK, but it comes with its own set of quirks, so I would advise you to stick to either U or B. HTH Sujit "T.Jalaludeen" <jala@hpsgm99.sgp.hp.com> on 05/06/99 02:41:18 AM To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: NOT IN TRANSACTION Author : Jalal E-mail : jala@hpsgm99.sgp.hp.com Question : When I use a BEGIN WORK, COMMIT WORK in my 4gl code, I get an error saying "TRANSACTION NOT AVAILABLE" I am using Informix -Online Dynamic Server How do I turn on the transaction logging.