15.00 - AccessLockForUncomRead - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

AccessLockForUncomRead

Purpose  

Determines whether SELECT requests embedded in INSERT...SELECT, UPDATE...SELECT, and DELETE...SELECT requests place READ or ACCESS locks on the source table.

Field Group

General

Valid Settings

 

Setting

Default Locking for Outer SELECT
and Ordinary SELECT Subqueries

Default Locking for SELECT Embedded In
DELETE, INSERT, MERGE, or UPDATE Request

TRUE

READ

ACCESS

FALSE

READ

READ

Default

FALSE

Changes Take Effect

After the DBS Control Record has been written.

Related Topics

 

For more information on…

See…

Locks and concurrency control

SQL Request and Transaction Processing.

Session isolation level

SQL Request and Transaction Processing.