Re: sqlca interface and "set lock mode"

Posted in 1999

Topics: Transactions, Locking & Isolation

Joan Carles Cladellas — Wed, 28 Jul 1999 09:38:39 +0200 — source: Informix-list mailing list archive (1991-1998)

You can set the Lock value in a script as a property of the Transaction object. SQLCA.Lock = "value" where value is the lock value you want to set. Lock Values ------------------ Dirty Read Committed Read Cursor Stability Repeatable Read (Only applicable for Online, SE not supports it)

↪ replying to Joan Carles Cladellas

FProse — Wed, 28 Jul 1999 06:57:10 -0700 — source: Informix-list mailing list archive (1991-1998)

Sorry, what you're describing is the PowerBuilder Parameter to affect the Informix "SET ISOLATION". I want to adjust the "SET LOCK MODE TO WAIT" value. Thanks anyway. >You can set the Lock value in a script as a property of the Transaction >object. > >SQLCA.Lock = "value" > >where value is the lock value you want to set. > >Lock Values >------------------ >Dirty Read >Committed Read >Cursor Stability >Repeatable Read > >(Only applicable for Online, SE not supports it) >

Glossary

isolation level