FW: d/w informix extract scripts

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