tags:

views:

100

answers:

1

How can we change the default lock in Progress instead of Share-lock?

+6  A: 

You can change it on each individual query (FIND, FOR EACH etc) by adding the lock status to the query using the [NO|EXCLUSIVE|SHARE]-LOCK modifier. If you leave this off, you get the default SHARE-LOCK.

You can also compile your code in a session started with the -NL parameter, which changes the default for that r-code into NO-LOCK.

nwahmaet