Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Locks for select clause

Hi,

I am looking for the lock clause to be used with "SELECT" statement for the following scenarios:

Read Lock:

Update Lock:

To make things easy to illustrate, this is what is used for 2 different databases to achieve the same.

MySQL

======

Read Lock: default

Update Lock: "LOCK IN SHARE MODE"

Oracle:

=====

Read Lock: default

Update Lock: "FOR UPDATE"

Regards

Raja

Former Member
Former Member replied

Hi,

perhaps you may want to read a little bit more details about the different options of the lock-option:

http://maxdb.sap.com/doc/7_6/da/ed9036dfe4b903e10000009b38f889/frameset.htm

And please see the difference between optimistic and exclusive lock.

Elke

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question