If you choose the SQL Preprocessor option ISOLEVEL=U, the access plan is read-only and your application cannot execute the SQL statements INSERT, UPDATE, or DELETE.
In addition, a share lock is not acquired for rows accessed with SELECT INTO or through a cursor, which means you may access rows inserted or updated by other concurrent tasks that have not been committed and may therefore be backed out.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|