RE: isolation in an ACE report
Rob Konikoff asked how to set dirty read isolation in an ACE report on OnLine 7.23 and INFORMIX-SQL 7.20 because locks cut reports short. Eric Rowell found an FAQ entry for the undocumented SACEISOL environment variable, with values such as DIRTY READ, ignored by SE. Jonathan Leffler added that the Perform equivalent is SPERISOL.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
I sent this to classics@iiug.org, but it never hit the list. This is a repost. Is there a way to set isolation to dirty read in an ace report? I've noticed that when a table has a lock on it, the ace report stops reading at the point of the lock and then produces output, many times leaving out LOTS of the data. INFORMIX-OnLine Version 7.23.UC11 INFORMIX-SQL Version 7.20.UD1 HP-UX 11 Rob
Can you put it in the Perform definition? I haven't worked with ACE reports in many years. Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Konikoff, R.... Sent: Monday, February 13, 2006 3:24 PM To: ids@iiug.org Subject: RE: isolation in an ACE report [6373] I sent this to classics@iiug.org, but it never hit the list. This is a repost. Is there a way to set isolation to dirty read in an ace report? I've noticed that when a table has a lock on it, the ace report stops reading at the point of the lock and then produces output, many times leaving out LOTS of the data. INFORMIX-OnLine Version 7.23.UC11 INFORMIX-SQL Version 7.20.UD1 HP-UX 11 Rob ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.
Rob, I found the following that may help. http://www.iiug.org/resources/faq/ifaq04b.htm.1#4.3.3 4.3.3 How can I set isolation levels in an ACE report? On 7th Oct 1998 Kate_Tomchik@HomeDepot.COM (Kate Tomchik) wrote:- Thanks for all the responses regarding setting isolation levels in Ace. Since so many of you asked for confirmation of this undocumented feature, here is the scoop: The environment variable is SACEISOL and the valid values are: DIRTY READ or dirty read COMMITTED READ or committed read CURSOR STABILITY or cursor stability REPEATABLE READ or repeatable read -for Bourne or Korn- SACEISOL="CURSOR STABILITY" export SACEISOL If you use SACEISOL with SE, it is ignored. No error is returned. Eric B. Rowell On 2/13/06, Konikoff, R.... <rob.konikoff@us.army.mil> wrote: > > > I sent this to classics@iiug.org, but it never hit the list. This is a > repost. > > Is there a way to set isolation to dirty read in an ace report? > > I've noticed that when a table has a lock on it, the ace report stops > reading at the point of the lock and then produces output, many times > leaving out LOTS of the data. > > INFORMIX-OnLine Version 7.23.UC11 > INFORMIX-SQL Version 7.20.UD1 > HP-UX 11 > > Rob > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >
On 2/13/06, Eric Rowell <erowell@gmail.com> wrote: > I found the following that may help. > > http://www.iiug.org/resources/faq/ifaq04b.htm.1#4.3.3 > > 4.3.3 How can I set isolation levels in an ACE report? > > On 7th Oct 1998 Kate_Tomchik@HomeDepot.COM (Kate Tomchik) wrote:- > > Thanks for all the responses regarding setting isolation levels in Ace. > Since so many of you asked for confirmation of this undocumented feature, > here is the scoop: > > The environment variable is SACEISOL and the valid values are: > > DIRTY READ or dirty read COMMITTED READ or committed read CURSOR STABILITY > or cursor stability REPEATABLE READ or repeatable read > > -for Bourne or Korn- SACEISOL="CURSOR STABILITY" export SACEISOL > > If you use SACEISOL with SE, it is ignored. No error is returned. > Eric B. Rowell > > On 2/13/06, Konikoff, R.... <rob.konikoff@us.army.mil> wrote: > > Is there a way to set isolation to dirty read in an ace report? > > > > I've noticed that when a table has a lock on it, the ace report stops > > reading at the point of the lock and then produces output, many times > > leaving out LOTS of the data. > > > > INFORMIX-OnLine Version 7.23.UC11 > > INFORMIX-SQL Version 7.20.UD1 > > HP-UX 11 Good catch. The equivalent variable for Perform is SPERISOL. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/