I need to know how to structure an Update SQL statement that will only update the rows that are not locked. We have a situation where some of the rows of a table are locked by some batch and/or interactive jobs and our update statement thows an error when a rowlock is found. The data is such that there is no way to identify the rows that are locked, and the program locking the files is a 3rd party system so not open to change.
I have done some analysis of UDB Isolation level optoins but none of them seem to have the desired effect.
our AS400 5R4