Re: Isolation level on Informix 9.3

Posted in 2007

Fernando Nunes — Sat, 17 Mar 2007 18:24:28 +0000 — source: Usenet: comp.databases.informix

agnoluck wrote: > Hi, > I have this problem: > > I have a Business Intelligence application (Board MIT) who reads data > from an Informix Server 9.3 on AIX OS. > > Board connect to DB server using ODBC driver, but when read some > transacted record, operation fails. I know exists the ISOLATION LEVEL > DIRTY READ to bypass this problem, but I can't send the command from > my application. So I try use Open Link ODBC Access, a third part > driver for Informix: it permit to send a command to server on > connection, but the command I send (SET ISOLATION TO DIRTY READ) has > effect only on first read, but the following read come to default > isolation level. > > Someone know how can I solve my problem? > > Thanks. > If you're just running one query, maybe you can create a stored procedure with it and include the set isolation in there... This will not be useful if you have a lot of queries... Regards. Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...