RE: isolation in an ACE report
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/