Oninit cdi / Archive
Talk to an expert →

Re: Setting Isolation mode for ACE reports

Posted in 2000

Topics: Transactions, Locking & Isolation

Colin McGrath — — source: Informix-list mailing list archive (1991-1998)

Surfer! wrote: > > We can put 'set isolation mode to dirty read;' in SQL statements. > > How can we do this for an ACE report, please? The user is having lots > of problems with them falling over on locked rows. This has happened > since moving to 7.20 tools from 6.05 tools. For ACE: export SACEISOL="dirty read" For PERFORM screens: export SPERISOL="dirty read" -- Colin

↪ replying to Colin McGrath
Surfer! — — source: Informix-list mailing list archive (1991-1998)

In article <89e8uu$11g$1@news.xmission.com>, Colin McGrath <cmm@trac3000.ueci.com> writes > >Surfer! wrote: >> >> We can put 'set isolation mode to dirty read;' in SQL statements. >> >> How can we do this for an ACE report, please? The user is having lots >> of problems with them falling over on locked rows. This has happened >> since moving to 7.20 tools from 6.05 tools. > >For ACE: >export SACEISOL="dirty read" > >For PERFORM screens: >export SPERISOL="dirty read" This looks the business. I will get my customer to try it out. Many thanks! > -- Surfer!

Glossary