Setting isolation level in Ace

Posted in 2004

Topics: Transactions, Locking & Isolation

Andy Kent — 3 Mar 2004 03:36:57 -0800 — source: Usenet: comp.databases.informix

I seem to recall reading about some environment variable (ACEISOL or something?) that you can set to determine the isolation level an Ace report will pick up. But I can't find anything about this in the manuals. Does anyone know how this is done? Andy

↪ replying to Andy Kent

Paul Watson — Wed, 03 Mar 2004 11:45:18 +0000 — source: Usenet: comp.databases.informix

Try running strings on the binary and see if you can spot it?? Andy Kent wrote: > > I seem to recall reading about some environment variable (ACEISOL or > something?) that you can set to determine the isolation level an Ace > report will pick up. But I can't find anything about this in the > manuals. > > Does anyone know how this is done? > > Andy -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #

↪ replying to Andy Kent

Malc — Wed, 3 Mar 2004 11:58:45 +0000 (UTC) — source: Usenet: comp.databases.informix

Yup, it's "SACEISOL". There's also "SPERISOL" for forms. Not sure where (or if) it's documented. Malc "Andy Kent" <andykent.bristol@virgin.net> wrote in message news:a3525a11.0403030336.42a660c8@posting.google.com... > I seem to recall reading about some environment variable (ACEISOL or > something?) that you can set to determine the isolation level an Ace > report will pick up. But I can't find anything about this in the > manuals. > > Does anyone know how this is done? > > Andy

↪ replying to Malc

Andy Kent — 3 Mar 2004 07:19:24 -0800 — source: Usenet: comp.databases.informix

Thanks, that's the one. Any idea what values it takes? I remember seeing it either in some Release Notes or marketing blurb, but I've never seen it in any manual. Unless it's very well hidden. Andy "Malc" <malc_p@btinternet.com> wrote in message news:<c24h9l$ed8$1@sparta.btinternet.com>... > Yup, it's "SACEISOL". There's also "SPERISOL" for forms. > Not sure where (or if) it's documented. > Malc > "Andy Kent" <andykent.bristol@virgin.net> wrote in message > news:a3525a11.0403030336.42a660c8@posting.google.com... > > I seem to recall reading about some environment variable (ACEISOL or > > something?) that you can set to determine the isolation level an Ace > > report will pick up. But I can't find anything about this in the > > manuals. > > > > Does anyone know how this is done? > > > > Andy

Glossary

isolation level