Vikas Nanchahal wrote:
>
> Somebody pl. advise.
>
> We are using Informix-Newera 2.12 and Informix online ver 5.0. We are
> using pessimistic locking in the supertables.
>
> Suppose i am working on two different supertables in two different
> windows simultaneously. I retrieve the records in the first window and
> start editing the record. now as soon as i start editing the record,
> it gets locked. now without applying the changes, i go on to the next
> window and retrieve the reocrds here also and start editing a record
> here also. after making changes here, i apply the changes to save the
> record and go on to the first window where i had started editing a
> record.
>
> NOW when i try to apply the record here, it gives me an error -259,
> Cursor not open.
>
> so what i understand that as soon as i apply the record in the first
> window, all the transactions are committed and all the cursors closed.
> so how to avoid the closure of the cursor of the first window, where i
> have not actually applied.
DECLARE fred CURSOR FOR ... WITH HOLD;
The WITH HOLD clause will preserve the cursor across transactions.
Art S. Kagel