Chapter Contents

Previous

Next
READ_LOCK_TYPE=

READ_LOCK_TYPE=



Specifies how data in a DBMS table is locked during a read transaction.

Default value: DBMS specific
See Also: UPDATE_LOCK_TYPE=
READ_LOCK_TYPE= LIBNAME option


Syntax
Details

Syntax

READ_LOCK_TYPE=ROW | PAGE | TABLE | NOLOCK

ROW
locks a row if any of its columns are accessed.

PAGE
locks a page of data, which is a DBMS-specific number of bytes.

TABLE
locks the entire DBMS table.

NOLOCK
does not lock the DBMS table or any rows during a read transaction.


Details

If you omit READ_LOCK_TYPE=, you get either the default action for the DBMS that you are using, or a lock for the DBMS that was set with the LIBNAME statement. You can set a lock for one DBMS table by using the data set option or for all tables in a particular DBMS by using the LIBNAME statement option.

If you specify READ_LOCK_TYPE=TABLE, you must also specify CONNECTION=UNIQUE, or you will receive an error message. Setting CONNECTION=UNIQUE ensures that your table lock is not lost, for example, due to another table closing and committing rows in the same connection.

See your DBMS chapter for details on the option values supported for your DBMS.


Chapter Contents

Previous

Next

Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.