locking_specification - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™
LOCKING
Type of lock to be placed on a database, table, view, or row hash. This setting will override any default lock placed on that object by the system.
You can specify a LOCKING clause in the seed portion of a recursive view definition, but not in the recursive portion of its definition.
lock_type
Severity of the lock to be placed when accessing base tables through this view as:
  • ACCESS
  • READ
  • WRITE
  • EXCLUSIVE
  • LOAD COMMITTED
MODE
Optional keyword.
NOWAIT
Specifies that if the indicated lock cannot be obtained, the request using this view should be aborted.
This option is used to avoid a potential deadlock situation, where a request is waiting for resources, possibly tying up other resources in the process of waiting for a lock to become available.