Flemming Frandsen wrote:
> I'd like to insert into a table, without *ever* setting a single lock.
It is NOT possible to avoid locking of a dml
(insert/update/delete)-call.
> I want to insert into the table and I want other processes to
> be able to
> read the data before I commit.
Let those other processes use isolation level 0
(see reference manual --> transactions for full explanation)
for their whole session (connect-option) or this special select
(see reference manual --> ...--> lock_option
http://www.sapdb.org/htmhelp/e2/55683ab81fd846e10000000a11402f/frameset.htm
)
> I also want to make sure that when I select from that same table in
> other clients that I don't set any locks either, in fact it would be
> cool if I could avoid checking for locks on the rows.
Isolation level 0 will neither check for locks held by other users
nor
lock itself --> the so-called dirty read seems to be ok for you
Elke
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
