Oninit cdi / Archive
Talk to an expert →

Re: Isolation Levels

Posted in 2000

Topics: Transactions, Locking & Isolation, Versions, Editions & End-of-Life

Jonathan Leffler — — source: Informix-list mailing list archive (1991-1998)

On Tue, 26 Sep 2000, Daryl Craig-Elliot wrote: >Running IDS 7.30 UC7-1 for Linux. > >I noticed whilst trawling the iiug archives two environment variables >for setting default isolation levels for ACE & PERFORM, SACEISOL & >SPERISOL respectively. > >I was wondering if there is a similar variable for setting a general >isolation level? No. >If not, what is the scope of a 'SET ISOLATION' command? From when it is run to the end of the session. >If I am running a simple isql script or series of scripts through a >shell programme do I have to set the isolation level in each script? Yes. -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"

↪ replying to Jonathan Leffler
Daryl Craig-Elliot — — source: Informix-list mailing list archive (1991-1998)

Jonathan Leffler wrote: > On Tue, 26 Sep 2000, Daryl Craig-Elliot wrote: > >Running IDS 7.30 UC7-1 for Linux. > > > >I noticed whilst trawling the iiug archives two environment variables > >for setting default isolation levels for ACE & PERFORM, SACEISOL & > >SPERISOL respectively. > > > >I was wondering if there is a similar variable for setting a general > >isolation level? > > No. > > >If not, what is the scope of a 'SET ISOLATION' command? > > From when it is run to the end of the session. > > >If I am running a simple isql script or series of scripts through a > >shell programme do I have to set the isolation level in each script? > > Yes. > BOO HISS!! Thanks Jonathan... I think. Time to modify lots of scripts. 8O( Daryl. > > -- > Yours, > Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> > Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN > "I don't suffer from insanity; I enjoy every minute of it!"

Glossary