REREAD_EXPOSURE= LIBNAME Statement Option

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

Syntax

REREAD_EXPOSURE=NO | YES

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.

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.