Re: Locking outside COMMIT WORK

Ian Goddard wrote: > > Bryan, > > It seems that a CURSOR WITH HOLD does much of what you want, especially > if combined with FOR UPDATE. Without being able to lay hands on a > manual I can't remember whether the combination is allowed or not. >... Nice try - it would be nice if it worked. A CURSOR WITH HOLD can be combined with FOR UPDATE, but be aware that after a COMMIT WORK, all locks are released. You then have to begin a new transaction to be able to fetch the next row which will be locked in that transaction, but all previously fetched rows have been released. I agree that being able to lock outside of transactions would be a useful feature. Is there any theoretical reason why it shouldn't exist? ---------------------------------------------------------------------- John H. Frantz Power-4gl: Extending Informix-4gl frantz@centrum.is http://www.strengur.is/~frantz/pow4gl.html