• Print |
• E-mail  |
• Bookmark

If you use a LIBNAME statement with the Access engine and the
ACCESS=READ_ONLY option in conjunction with a DATA step where you use
the KEY= option, SAS will fail with the following error:

ERROR: MEMBER level locking for UPDATE or RANDOM access is not
       supported by this engine.

Example:

   libname x oracle user=scott pw=tiger access=readonly
   data new; set kv;
     set x.test ( dbkey=c1) key=dbkey; run;
   run;

When ACCESS=READ_ONLY is specified, the RANDOM access attribute is
turned on for the DBMS engine.

The current workaround is to remove the ACCESS=READ_ONLY, and if
needed add READLOCK_TYPE=TABLE.

Operating System and Release Information