Re: INFORMIX-CLI and isolation level

Posted in 1998

Nils Myklebust — Tue, 28 Jul 1998 04:42:14 GMT — source: Informix-list mailing list archive (1991-1998)

On 27 Jul 1998 15:40:08 GMT, william@carsinfo.com (William Harris) wrote: >In article <35BC35DD.C23@cpm.elex.co.il>, berko@cpm.elex.co.il says... >>is anybody know if i can change the default isolation level when i work, >>for example with Access, through INFORMIX-CLI ? > >Look at the documentation for SQLSetConnectOption, specifically the >SQL_TXN_ISOLATION option. For dirty reads, you probably want >SQLSetConnectOption(hdbc, SQL_TXN_ISOLATION, SQL_TXN_READ_UNCOMMITED). A little hard to use from inside MS Acces though :-) Otherwise see my other post in this thread. Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)