Cursors
Posted in 1997
Deepak Pant — — source: Informix-list mailing list archive (1991-1998)
Hello, I have a query regarding the informix cursors. The usual behaviour on the opening of the cursor is that a number of records which match the where clause in the open cursor statement are fetched. A fetch from the cursor fetches the records from the local cache and not from the server. In my application this is causing a problem since other informix sessions may be updating the table as well and hence the values which are provided by the cursor may be invalid. Now is it possible that whenever I issue a fetch cursor the records are fetched from the server/database itself and not the cursor which probably has gone stale. Regards Deepak