rollback while updation

rollback while updation

 

  

Hi All,

I'm having a temp table from which i'm fetching all the data and using a
cursor within a for loop I'm tryin to update another table.
Now prob is that in the updatable table if there is/are any row level
lock, the whole updation is getting rollback.
In this case I want to ignore the row level locked rows and update others.

Ny suggestions??

Regards,
Sourav


DB2 & UDB email list listserv db2-l LazyDBA home page