Query Optimization with COALESCE function in db2 udb

Solved: my query is as below select _ID, _ID, coalesce as REDUNDANT_STOCK_ID from STOCK_ARRIVAL SA

I'm trying to run the following query which was previously working wrapped in SAS hitting DB2 tables I'm moderately aware that TD does not

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

coalesce db2 DB2 is to check for NULL values and it can be used in place of NULL indicator or COALESCE function The VALUE function replaces the column