Trigger error [5429] when using COALESCE: A triggered action statement contained an invalid referenc

Database
Enthusiast

Trigger error [5429] 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 [5429] 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;
);

 

Thanks, Carl

  • coalesce
  • error 5429
  • trigger