READ_LOCK_TYPE=

READ_LOCK_TYPE=

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

Default value: None

Syntax
Details

Syntax

READ_LOCK_TYPE= TABLE|VIEW

TABLE: locks the entire table during a read operation.
VIEW: locks the entire view during a read operation.

Details

If you do not use any SAS/ACCESS read lock options, Teradata locks at either the row or table level. Since SAS/ACCESS does not currently support a ROW lock, specify TABLE or VIEW only when you must lock the entire table or view.

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