Oninit cdi / Archive
Talk to an expert →

Re: Isolation Level

Posted in 2000

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Server Administration, Transactions, Locking & Isolation

Mark D. Stock — — source: Informix-list mailing list archive (1991-1998)

eonder@my-deja.com wrote: > > Hello, > > I have found in the informix forum that for setting isolation level for > ACE report exist the environment variable SACEISOL. Is there an > environment variable for set isolation level for 4gl, isql, dbaccess > tools? No, but there is an SQL command to set the isolation level that you can use in each of those tools. Check out the SET ISOLATION command for the full syntax. Ace is part of the ISQL package, as is Perform. If you want to set the isolation level in Perform, then there is another environment variable called SPERISOL. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+

↪ replying to Mark D. Stock
Andrew Hamm — — source: Informix-list mailing list archive (1991-1998)

Mark D. Stock wrote in message <916bhp$ihp$1@news.xmission.com>... > >No, but there is an SQL command to set the isolation level that you can >use in each of those tools. Check out the SET ISOLATION command for the >full syntax. Dang. I too was hoping for a set-n-forget variable for dbaccess and isql so that I don't have to remember or educate users. Hey - I read (in Tech Notes Vol10 issue 3) that XPS supports stored procedures called public.sysdbopen() "user".sysdbopen() I don't suppose the more mundane engines support that too? I suppose I COULD test it for myself ;-(

↪ replying to Andrew Hamm
Andrew Hamm — — source: Informix-list mailing list archive (1991-1998)

Andrew Hamm wrote in message <3a36bc4e@news.iprimus.com.au>... > >Hey - I read (in Tech Notes Vol10 issue 3) that XPS supports stored >procedures called > >public.sysdbopen() >"user".sysdbopen() > >I don't suppose the more mundane engines support that too? I suppose I COULD >test it for myself ;-( I've tested, and it appears not to be supported on 7.30 engine. Sigh.

Glossary