Chapter Contents
Previous
Next
READ_LOCK_TYPE=

READ_LOCK_TYPE=


Specifies how a table is locked during read operations.

Default value: Defaults to the value of the LIBNAME option.

Details

Details

If you specify READ_LOCK_TYPE=NOLOCK, table locking is not used when the data set is read. If you specify READ_LOCK_TYPE=ROW, the ORACLE "ROW SHARE" table lock is used when the data set is read. If you specify READ_LOCK_TYPE=TABLE, the ORACLE "SHARE" table lock is used when the data set is read.

When READLOCK_TYPE is set to either TABLE or ROW, the CONNECTION option must be set to UNIQUE. If not, an error occurs.

For a full description of this option, refer to READ_LOCK_TYPE=.


Chapter Contents
Previous
Next
Top of Page

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