SAP HANA Triggers

Trigger

Name: TRG_DICO_UPDATE

Content:

CREATE TRIGGER TRG_DICO_UPDATE AFTER UPDATE ON DICO REFERENCING NEW ROW NEWDICO, OLD ROW OLDDICO FOR EACH ROW BEGIN IF (:NEWDICO.VALUE < 0) OR (:OLDDICO.STATUS > 1 AND :NEWDICO.VALUE < :OLDDICO.VALUE AND :OLDDICO.TYPE = 0) OR (:OLDDICO.STATUS > 1 AND :NEWDICO.VALUE > :OLDDICO.VALUE AND :OLDDICO.TYPE = 1) THEN SIGNAL SQL_ERROR_CODE 10001 SET MESSAGE_TEXT = 'The DICO value cannot be lower than 0 or DICO status is NOT_USABLE'; END IF; END;

Trigger

Name: TRG_DICO_CREDIT_UPDATE

Content:

CREATE TRIGGER TRG_DICO_CREDIT_UPDATE AFTER UPDATE ON DICO REFERENCING NEW ROW NEWDICO FOR EACH ROW BEGIN IF (:NEWDICO.TYPE = 1) THEN INSERT INTO DICO_TEMP VALUES(:NEWDICO.COUN_KEY, :NEWDICO.HOLD_OID, :NEWDICO.VALUE); END IF; END;