UPDATE_LOCK_TYPE=

UPDATE_LOCK_TYPE=

Specifies and changes the scope of the Teradata lock during SAS/ACCESS update operations.

Default value: None

Syntax
Details

Syntax

UPDATE_LOCK_TYPE= TABLE|VIEW

TABLE: locks the entire Teradata DBMS table during an update operation.
VIEW: locks the entire Teradata DBMS view during an update operation.

Details

If you do not use any SAS/ACCESS update locking options, Teradata locks at either the row or table level. Since SAS/ACCESS does not currently support row-level locking, specify TABLE or VIEW only when you must lock the entire table or view. Use SAS/ACCESS locking options only when Teradata's standard locking is undesirable. For more information, see the LOCKING modifier in your Teradata SQL Reference manual, as well as Understanding the Scope of SAS/ACCESS Lock Options.

Chapter Contents
Previous
Next
Top of Page