Re: Default ISOLATION LEVEL???

Posted in 1995

Jonathan Leffler — 17 Apr 1995 12:03:19 -0400 — source: Informix-list mailing list archive (1991-1998)

I4GL does not set the isolation level -- therefore the default depends on the database. If it is logged and MODE ANSI, the default is REPEATABLE READ. If it is logged but not MODE ANSI, it is COMMITTED READ. If it is unlogged, the log mode approximates to COMMITTED READ. All this applies to OnLine only, of course -- isolation level does not apply to SE. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> >From: bpayne@netcom.com (Bob Payne) >Date: Fri, 14 Apr 1995 14:37:53 GMT >X-Informix-List-Id: <news.13043> > >What is the default isolation level in 4GL? We are running both 5.X and >7.1 versions of the engine. Our 'experts' say its REPEATABLE READ, but >we are having problems proving that.