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

Posted in 1998

Klaus Gotthardt — Thu, 10 Sep 1998 10:43:17 +0200 — source: Informix-list mailing list archive (1991-1998)

Jonathan Leffler wrote: > > On Tue, 8 Sep 1998 Rajesh_Kapur@spartanstores.com wrote: > > > I could set 'isolation to dirty read' using isql and running the ace report > > under the same session of isql. Is there a way to set isolation to dirty > > read when using sacego from a shell script? > > RTFM and/or the Release Notes. > > SACEISOL (or minor variants on that theme) is the variable. A suitable > value is "dirty read". > > Similarly for Perform, using SPERFISOL. > > Check the spelling of the variables, especially the Perform version. Use > all upper case or all lower case in the value, and a single space between > the words, and no leading or trailing spaces. If you break those rules, > your value will be ignored. > > 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 Is there a way to set the isolation level using ODBC (cli 2.5)? -- Klaus Gotthardt, Johann Wolfgang Goethe-Universit't,Verwaltungsdatenverarbeitung Email: K.Gotthardt@em.uni-frankfurt.de Tel:+49 (0)69-798-23380 Fax:+49 (0)69-798-23381 Home,pgp-key: http://www.rz.uni-frankfurt.de/~gotthard