Benoit Menendez wrote: > > Can someone indicate me a way to support "long" transaction > that insert, > update or delete records without locking the other thread > that are just > interested in the non-committed records... I wish the > isolation level 1 > would just skip the uncommitted inserts from other concurrent > transactions > without locking...
With release 7.3.0.21 you can use a new, til now undocumented, extension of the lock option. With "lock (ignore)" a transaction doesn't wait on uncommited rows from other transactions but skip them. This is only supported for isolation level 1. So your statement should look like "select ... from T where ... with lock (ignore)" HTH. Kind regards Holger SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
