Background documentation-7061: LOCK ROW for this table not allowed Locate this document in the navigation structure

 

Explanation

A LOCK statement with a ROW specification can only be executed for an updatable join view table. However, not even updatable join view tables allow a ROW specification with OPTIMISTIC.

User Response

The effect can be achieved using several ROW specifications issued on the underlying base tables.