Re: FW: d/w informix extract scripts
Hi,
To pass by this error, just run the statement, before "select" statement:
SET ISOLATION TO DIRTY READ;
SELECT ......
Regards. RFo
"David Williams" <djw@smooth1.fsnet.co.uk> wrote in message news:<c617f0$1la$1@newsg4.svr.pol.co.uk>...
> "Paul Watson" <paul@oninit.com> wrote in message
> news:4083F0FF.72A5C18F@oninit.com...
> > There is a lock on one of the tables
> >
>
> There is no isam error listed so we cannot be sure...get the person to
> list the isam error
> as well.
>
> > "McCabe-Reed, Barbara SIK" wrote:
> > >
> > > Can someone indicate what is going on with the below error that the
> users
> > > are receiving? Thanx.
> > >
> > > > -----Original Message-----
> > > > From: Nash, Laurie SIK
> > > > Sent: Monday, April 19, 2004 10:32 AM
> > > > To: McCabe-Reed, Barbara SIK; Berlenbach, Elizabeth C SIK
> > > > Cc: Guliano, Christine A SIK; Nash, Laurie SIK
> > > > Subject: FW: d/w informix extract scripts
> > > >
> > > > Barbara,
> > > >
> > > >
> > > > Below is the message we get that stops the extract from completing.
> > > >
> > > > 244: Could not do a physical-order read to fetch next row.
> > > > Error in line 123> > > > Near character position 20
> > > >
> > > >
> > > >
> > > >
> > > > The sql that executes are simple extracts, such as:
> > > >
> > > > select a.*, order_no
> > > > from fourgen.stoshipd a, fourgen.stoordre b
> > > > where a.doc_no = b.doc_no
> > > >
> > > > Does this help any??
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: Guliano, Christine A SIK
> > > > Sent: Monday, April 19, 2004 10:21 AM
> > > > To: Nash, Laurie SIK
> > > > Subject: d/w informix extract scripts
> > > >
> > > >
> > > > Laurie,
> > > > This is the message we see when we get the row lock
> condition:
> > > >
> > > >
> > > > 244: Could not do a physical-order read to fetch next row.
> > > > Error in line 123> > > > Near character position 20
> > > >
> > > >
> > > > Below are the extract jobs method of data retrieval:
> > > >
> > > >
> > > > Job A50EO15E order header extract uses:
> > > >
> > > > This script will start sql *
> > > > /sikorsky/pgmY/aix/fgen/sik/vers10/sql/stoordre.sql
> > > > Sql to run
> > > > unload to /local/tmp1/stoordre.dat> > > >
> > > >
> > > > Job A50EO14E order line extract uses:
> > > >
> > > > This script will start sql *
> > > > /sikorsky/pgmY/aix/fgen/sik/vers10/sql/stoordrd.sq
> > > > Sql to run
> > > > unload to /sikorsky/pgmY/aix/fgen/sik/vers10/data/stoordrd.dat> > > >
> > > >
> > > > Job A50EO18E order shipment extract uses:
> > > >
> > > > This script will start sql *
> > > > /sikorsky/pgmY/aix/fgen/sik/vers10/sql/stoshipd.sq
> > > > Sql to run
> > > > unload to /sikorsky/pgmY/aix/fgen/sik/vers10/data/stoshipd.dat> > > >
> > > >
> > > > Please let me know what you find out. Thanks.
> > > >
> > > >
> > > >
> > > > Regards,
> > > > Christine Guliano
> > > > Spares Group
> > > > Sikorsky Aircraft - Information Technology
> > > > Ext. 6-5020 E-mail cguliano@sikorsky.com
> > > > Phone 203-386-5020
> > > > E-fax 860-998-4869
> > > >
> > > sending to informix-list
> >
> > --
> > Paul Watson #
> > Oninit Ltd # Growing old is mandatory
> > Tel: +44 1436 672201 # Growing up is optional
> > Fax: +44 1436 678693 #
> > Mob: +44 7818 003457 #
> > www.oninit.com #