Re: Cursor Problem

Abhay Mannur wrote: > > Hi, > Environment : ODS 7.22uc2 > ERP : PeopleSoft 6.01 > We have 2 databases in one Informix server. > There is an application written in SQR. Which uses a cursor and > reads one row, change some of the values and adds a new row with > those new values in the same table. > This works well in one database and fails in other though everything > is same for the table. ( Even data ) > The select cursor is reading the rows which are being inserted. > And that's causing a problem. > > What could be wrong with that database ? > Why is it reading the new rows ? > > Thanks in advance. > > Abhay Mannur > Informix DBA > Fairchild Semiconductor A few ideas off the top of my head (where else do they come from?): Is the locking the same in both databases? Is the transaction isolation level the same? -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk --- My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/