Re: Cursor Problem

Check if the isolation level is the same on both of the databases Mariusz Abhay Mannur <abhay@cheerful.com> wrote in article <6ikra7$dh8$1@news.xmission.com>... > > 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 >