15.00 - ACCESS Locking and Multistatement Requests - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

ACCESS Locking and Multistatement Requests

If you want each statement in a multistatement request to use row hash‑level ACCESS locking, specify the LOCKING ROW FOR ACCESS modifier preceding each individual SELECT statement in the multistatement request. See “Coding Multistatement Requests” on page 910 for additional details about how Teradata Database handles transactions, particularly those containing multistatement requests.