Your Browser is not longer supported

Please use Google Chrome, Mozilla Firefox or Microsoft Edge to view the page correctly
Loading...

{{viewport.spaceProperty.prod}}

LOCK MODE pragma

The LOCK MODE pragma sets the lock mode. It is only effective in SQL-DML statements.

The pragma can be used in CALL and in routines, see section "Pragmas in routines".


LOCK MODE EXCLUSIVE


If LOCK MODE EXCLUSIVE is specified, every access to the database connected directly or indirectly with this SQL statement involves exclusive locks. Otherwise the lock mode is defined by the system.

Powered by Atlassian Confluence and Scroll Viewport.