Re: MODE ANSI DATABASES

billy@west.co.za ("Billy Wheeler") wrote: :On 20 Nov 96 at 13:29, , @compuserve.com wrote: :> Does anybody know where I might find some kind of list to detail the :> differences between standard transaction logged databases and mode :> ANSI databases. :With MODE ANSI, you have unbuffered logging and you are always in a :transaction. You COMMIT or ROLLBACK, and you're automatically put :into a new transaction. :With standard logging, you have to explicitly say BEGIN WORK to open :a transaction. :Unbuffered logging means that the log buffer gets flushed to disk :immediately on COMMIT or ROLLBACK. Buffered logging means that only :full log buffers get flushed to disk. Checkpoints will also flush log :buffers. In addition there are several things you can only do when the database is NOT mode ANSI. There are several very usefull extensions to SQL that are not ansi standard. This is very well documented in the Informix manuals. I wouldn't dream of setting a database to mode ANSI. The limits are too large and the problems too many. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company