17.00 - locking_specification - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)
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.