RE: Transactions and Record Locking Help Needed

Posted in 1995

pigi@frumar.it — 15 Sep 1995 04:38:03 -0400 — source: Informix-list mailing list archive (1991-1998)

Bill, You will probably use a Select statement declare with hold "WITH HOLD" used in this way: DECLARE some_cursor CURSOR WITH HOLD FOR select something from ....FOR UPDATE. This will keep the lock on the table until you releas it with a CLOSE statement Hope this help Pierluigi "PIGI" Frullani Frumar S.r.l. P.S. Sorry for my not good english