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 821 for additional details about how Teradata Database handles transactions, particularly those containing multistatement requests.