If with(updlock) is used inside a nested transaction will the lock be released at the next or the final commit?
asked 17 Mar '15, 04:31
AFAIK, SQL Anywhere does not really support nested transactions. Even when using BEGIN TRANSACTION/COMMIT TRANSACTION for T-SQL compatibility, this should behave like "nested savepoints". Given that, I would think there is only one real "commit", and until that, the lock will be hold.
Breck has written en detail on that in his great book and has cited it here, too (and I'm free to take a quote from that, too:):
answered 17 Mar '15, 05:40