UPDATE_LOCK_TYPE=

UPDATE_LOCK_TYPE=

Specifies how a table is locked during update operations.

Default value: Defaults to the value of the LIBNAME option.

If you specify UPDATE_LOCK_TYPE=NOLOCK, table locking is not used during the reading of tables and views for update. If you specify UPDATE_LOCK_TYPE=ROW, the ORACLE "ROW SHARE" table lock is used when the data set is read for update. If you specify UPDATE_LOCK_TYPE=TABLE, the ORACLE "EXCLUSIVE" table lock is used when the table is read for update.

If UPDATE_LOCK_TYPE=NOLOCK and ORACLE_73_OR_ABOVE=YES, updates are performed using serializable transactions. If UPDATE_LOCK_TYPE=NOLOCK and ORACLE_73_OR_ABOVE=NO, updates are performed using an extra WHERE clause to ensure that the row was not updated since it was first read. Updates might fail when UPDATE_LOCK_TYPE=NOLOCK because other users might modify a row after the row was read for update.

If the ORACLE_73_OR_ABOVE= option is incorrectly set to YES (meaning that the Oracle server version is below 7.3), the Oracle engine detects this, and the update is performed as if ORACLE_73_OR_ABOVE= were correctly set.

For a full description of this option, refer to UPDATE_LOCK_TYPE=.

Chapter Contents
Previous
Next
Top of Page