Unanswered: alternative of with(updlock,readpast) of SQL server in DB2?
I have two thread..
1) Thread 1 selects the top record (status = 0) and places an exclusive lock on it, but allows read past and obtains ID.
2) Thread 2 selects the top record (status = 0) and cant select Thread 1s record because its locked but instead of being blocked is allowed to read past the current locked record to the next record
for this "select *from table with(updlock,readpast) where status=0" is used in SQL server but, I want the same functionality in DB2. Could anybody help me on this, its urgent as I am not getting it in google.