We do not have to retrieve data first and manipulate it before executing the SQL UPDATE. Avoiding that work requires an extra call to DB2. Below example dynamically retrieve a row, and update the Column value. suppose an employee is to be given a 10% raise. You could select the employee’s salary, add 10% to the value, … Continue reading DB2- Avoid Select Column Before do UPDATE