Re: changying from ANSI mode to unbuffered logging

Posted in 1998

Serina Lee — Fri, 13 Mar 1998 00:02:21 +0800 — source: Informix-list mailing list archive (1991-1998)

With unbuffered logging, "BEGIN WORK" and "COMMIT WORK" are required to execute a transaction. In contract, "BEGIN WORK" is not needed in ANSI logging. In addition, the isolation default value for unbuffered logging is COMMITTED READ while the isolation default for ANSI mode database is REPEATABLE READ. One more note to Online 7.x, the default for LOCK MODE is NOT WAIT. Serina. Standard disclaimers apply. ANTS wrote: > Hi all, > > We are planning to change the logging mode from ANSI to unbuffered logging. > Any consequences that we have to take in 4GL, stored procedures and > PowerBuilder applications?? > > Please advise.... > > Nien > =========================================== > Mails are checked daily and processed right away. > If you don't get my replies within 3 days please send your mail again.