REREAD_EXPOSURE= LIBNAME Statement Option

Specifies whether the interface behaves like a random access engine for the scope of the LIBNAME statement.

Valid in: LIBNAME statement
Default: NO
Supports: All

Syntax

REREAD_EXPOSURE= NO | YES

Syntax Description

NO

specifies that the engine behaves as a sequential engine with limited random access. This means that your data is protected by the normal data protection that SAS provides.

YES

specifies that the engine behaves like a random access engine when rereading a row so that you cannot guarantee that the same row is returned. For example, if you read row 5 and someone else deletes it, then the next time you read row 5, you will read a different row. You have the potential for data integrity exposures within the scope of your SAS session.

Details

CAUTION:
Using REREAD_EXPOSURE= could cause data integrity exposures.
Oracle Details: To avoid data integrity problems, it is advisable to set UPDATE_LOCK_TYPE=TABLE if you set REREAD_EXPOSURE=YES.
ODBC Details: To avoid data integrity problems, it is advisable to set UPDATE_ISOLATION_LEVEL=S (serializable) if you set REREAD_EXPOSURE=YES.