-7061: LOCK ROW for this table not allowed

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.