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
2009-08-24 17:50:24