Re: how can I set isolation to dirty read in ace reports?

Posted in 1998

Jonathan Leffler — Thu, 10 Sep 1998 12:47:34 -0700 (PDT) — source: Informix-list mailing list archive (1991-1998)

On Thu, 10 Sep 1998, Klaus Gotthardt wrote: > Jonathan Leffler wrote: > > On Tue, 8 Sep 1998 Rajesh_Kapur@spartanstores.com wrote: > > > Is there a way to set isolation to dirty read when using sacego? > > > > SACEISOL [...] is the variable. A suitable value is "dirty read". > > > > Similarly for Perform, using SPERFISOL. Actually, that's SPERISOL, not SPERFISOL. > Is there a way to set the isolation level using ODBC (cli 2.5)? Not that I know of, unless you execute some pass-through SQL which does an explicit "SET ISOLATION TO ...". Yours, Jonathan Leffler (jleffler@informix.com) #include <witticism.h> Guardian of DBD::Informix v0.60 -- http://www.perl.com/CPAN Informix IDN for D4GL & Linux -- http://www.informix.com/idn