to Lock a record in reading

[rleb...@enginfo.it]

Hi,

while reading a record , with SQL QUERY, how can I lock it for a future Update ????

I try with : ' SELECT * FROM [TABLE_NAME] WHERE [...] FOR UPDATE '

but it doesn't lock the record !!!!!

Thanks and sorry for my language !!

Rino

[PM (pm3iinc-nospam)]

what version of db2?
what platform?
what isolation level?
auto commit on? (should be off)

SELECT * FROM [TABLE_NAME] WHERE [...] FOR UPDATE WITH RS

In your case it probably locks the record but you're not fast enough to see
it.

PM

[boco...@ca.ibm.com]

What platform and what is your isolation level?

Sure it is locking the row! The issue is what isolation level are you? Furthermore, do
you mean not U locking, but is S locking instead? Or, you don't know? Running at an
upper isolation level is not necessarily the right answer. Can you answer the above
questions?