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.