Forcing uncommitted reads using SAS/ACCESS® Interface to DB2 in the Windows environment


To force an uncommitted read using SAS/ACCESS Interface to DB2, you need to include the Read_Isolation_Level=UR option in the LIBNAME statement.

You do not need the LOCK statement because SAS/ACCESS Interface to DB2 defaults to row-level locking.

If you do not use any options, a LIBNAME statement that is accessing the DB2 engine will default to the database default, which is typically READ_COMMITTED (although the database installation and configuration can be different).