User Profile

Collapse

Profile Sidebar

Collapse
ajaysbedi
ajaysbedi
Last Activity: Aug 3 '09, 10:31 AM
Joined: Jul 28 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • ajaysbedi
    replied to Merging Two Triggers
    in DB2
    Yes, i need to merge these two triggers and compile.
    See more | Go to post

    Leave a comment:


  • ajaysbedi
    started a topic Merging Two Triggers
    in DB2

    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);...
    See more | Go to post
No activity results to display
Show More
Working...