RE: Transactions and Record Locking Help Needed

> 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 Sorry but this is not actually true. You've got the purpose of a WITH HOLD cursor upside-down: its purpose is to prevent a cursor being closed after you do a commit. You still lose all the locks. akent@cix.compulink.co.uk (Andy Kent) ------------------------------------------------ Freelance Informix Database Specialist, Redland, Bristol, England