Oninit cdi / Archive
Talk to an expert →

Strange behaviour of FOREACH (INFORMIX-4GL Version 7.30.HC4P1)

Posted in 2005

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Transactions, Locking & Isolation, Platform-Specific Issues

Ravi — — source: Usenet: comp.databases.informix

Hi All, We are facing a very strange issue while using FOREACH. The environment is as follows: HP-UX 11.11 Informix 4GL 7.30.HC4P1 Informix Dynamic Server Version 9.30.HC2 4GL program is opening a cursor on table 'tab1' with certain conditions in the where clause. When a FOREACH is applied to traverse through this cursor, it is not returning all the rows which satisfy the conditions. Due to this, the output of the program is not as expected. The behaviour is also not consistent as sometimes it gives 'x' number of records less and sometimes it gives 'y' number of records less. Please note: (1) The cursor declared is a plain cursor and not scroll cursor and without any WITH HOLD clause. (2) The isolation is set to dirty read before opening the cursor. Kindly let us know if there is any resolution to this issue. Is this some kind of bug in Informix 4GL tool for the version mentioned above. Thanks. Regards, Ravi.

↪ replying to Ravi
scottishpoet — — source: Usenet: comp.databases.informix

ravi, it may be a bug in the server, 9.30.HC2 is now obsolete get your engine onto 9.40 or 10 and see if the problem still reproduces. Ravi wrote: > Hi All, > > We are facing a very strange issue while using FOREACH. The environment > is as follows: > > HP-UX 11.11 > Informix 4GL 7.30.HC4P1 > Informix Dynamic Server Version 9.30.HC2 > > 4GL program is opening a cursor on table 'tab1' with certain conditions > in the where clause. When a FOREACH is applied to traverse through this > cursor, it is not returning all the rows which satisfy the conditions. > Due to this, the output of the program is not as expected. The > behaviour is also not consistent as sometimes it gives 'x' number of > records less and sometimes it gives 'y' number of records less. > > Please note: > (1) The cursor declared is a plain cursor and not scroll cursor and > without any WITH HOLD clause. > (2) The isolation is set to dirty read before opening the cursor. > > Kindly let us know if there is any resolution to this issue. Is this > some kind of bug in Informix 4GL tool for the version mentioned above. > > Thanks. > > Regards, > Ravi.

Glossary