Re: INFORMIX-CLI and isolation level

Posted in 1998

William Harris — 27 Jul 1998 15:40:08 GMT — source: Informix-list mailing list archive (1991-1998)

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). -- William Harris william@carsinfo.com Check out the NAGS spam filter. http://www.nags.org