SQL Optimizer for DB2 ZOS 1

We have an Update job, which uses DB2 connector stage to update the DB2 table and coalesce =0 and _value > 0

The DB2 Design Advisor in IBM DB2 Universal Database^TM Version show how “time-coalesce” operation can be expressed directly in

coalesce db2 COALESCE returns the first argument that is not null The arguments are evaluated in the order in which

coalesce synonyms Specify to apply the SQL syntax transformation rule that adds COALESCE to a column When the data is retrieved, the COALESCE function, which in this case is