Archives of the TeradataForum
Message Posted: Wed, 07 Aug 2013 @ 12:32:08 GMT
Paul GRAHAM wrote:
Just add another LOCKING:
LOCKING TABLE a FOR ACCESS LOCKING TABLE b FOR ACCESS SELECT
Btw, i would prefer LOCK ROW ACCESS instead:
no need for adding all table names and it automatically upgrades to a table lock when neccessary.
In very old releases there used to be some problems with this approach (in some cases the row lock was upgraded to a table lock with READ instead of ACCESS), but now only some rare combinations in multi statemnet requests might show that behaviour (if at all).
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|