AW: lock problem
Thank you for the help.
Antje
> ----------
> Von: J.Cooper@MS03.dss.gsi.gov.uk[SMTP:J.Cooper@MS03.dss.gsi.gov.uk]
> Gesendet: Thursday, October 28, 1999 2:14 PM
> An: Sackwitz, Antje; Informix-list@iiug.org
> Betreff: Re: lock problem
>
>
> SET ISOLATION DIRTY READ;
> SELECT ...>
> > Hi,
> > coming from the Oracle world I focus a problem in my informix
> database.
> > In a table with a lot of concurrent activities on that table (insert
> ,
> > update, select)
> > and having a lot of rows the select very often runs into a lock and
> > therefore can't proceed the select.
> > How can I configure that reading the data is still possible or that
> the
> > concerned row is omitted, and select proceeds with the next row?
> > Any help is greatly appreciated.
> >
> > Antje Sackwitz
> >
> > -------------------------------------------------------------
> > Antje Sackwitz Phone +49-431-7109-514
> > Vossloh System-Technik GmbH Fax +49-431-7109-502
> > Edisonstr. 3 E-Mail sackwitz@vst.vossloh.de
> > 24145 Kiel
> > -------------------------------------------------------------
> >
>