Re: ACE program and isolation levels

From: r_pastore@my-deja.com > >How do you set the isolation level in an ACE program? No matter what I >do I get a grammatical error saying it doesn't understand the construct. >The statement I'm using is: > >SET ISOLATION TO DIRTY READ> >I've tried with and without semi-colon, before/after database statement >and in the body of the report. >I get a 243 error when I attempt to read a locked row so I have to >change the isolation to dirty read. >Any help would be appreciated. I think there's an environment variable called SACEISOL or something to that effect. _____________________________________________________________________________________ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com

Obnoxio The Clown wrote: > From: r_pastore@my-deja.com > >How do you set the isolation level in an ACE program? No matter what I > >do I get a grammatical error saying it doesn't understand the construct. > >The statement I'm using is: > > > >SET ISOLATION TO DIRTY READ> > > >I've tried with and without semi-colon, before/after database statement > >and in the body of the report. > >I get a 243 error when I attempt to read a locked row so I have to > >change the isolation to dirty read. > >Any help would be appreciated. > > I think there's an environment variable called SACEISOL or something to that > effect. There is indeed SACEISOL for ACE, and SPERISOL for Perform. The value needs to be in all lower case, no leading spaces, single embedded space, and one of the values: dirty read committed read cursor stability repeatable read Some other variations might work, but the value is silently ignored if it is not recognized. -- 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!"