Trigger error  when using COALESCE: A triggered action statement contained an invalid referenc
This CREATE TRIGGER fails because of the COALESCE function. (without it the trigger can be created!) Looks like COALESCE is not allowed in triggers.
"Failed  A triggered action statement contained an invalid reference"
Is there documention about (non-allowed) coding in triggers? Can anyone think of a workaround?
CREATE TRIGGER D0_BUS_EUDS.SimulationPricePlanUpdate2 AFTER UPDATE OF (PP_Comment) ON D0_BUS_EUDS.DSC_CNT_S_PRICE_PLANS_SIMULAT ORDER 1 REFERENCING OLD ROW as OldRow NEW ROW as NewRow FOR EACH ROW ( INSERT INTO D0_BUS_EUDS_TEC.DSC_TEC_R_LOGGING (script,step, log_comment) SELECT SimPer.Batch_Num,'aStep','Old: ' ||COALESCE(OldRow.PP_Comment,'')||' New: '||NewRow.PP_Comment FROM D0_BUS_EUDSV.DSC_NTL_R_SIMULATION_PERIOD SimPer; );