User Profile
Collapse
-
Yes, i need to merge these two triggers and compile. -
Merging Two Triggers
Hi,
I have 2 triggers on a table, both triggers are updating the another table
create trigger DB.TRG1 AFTER INSERT ON Table1REFERENCI NG NEW AS NEW FOR EACH ROW MODE DB2SQL WHEN ( NEW.DEPT <> OLD.DEPT)CALL COBOL_SP1 (NEW.DEPT,NEW.D EPT_NO)
CREATE TRIGGER DB.TG2 AFTER INSERT ON Table1REFERENCI NG NEW AS NEW FOR EACH ROW MODE DB2SQL WHEN ( NEW.DEPT =222 and OLD.DEPT = 111) CALL COBOL_SP2 (NEW.DEPT,NEW.D EPT_NO);...
No activity results to display
Show More
Leave a comment: