Results 1 to 2 of 2

Thread: Update Trigger

  1. #1
    Join Date
    Oct 2003

    Unanswered: Update Trigger

    Can some show me the syntax for a simple trigger on table? Sample: table1 and table2. If an update is made to field 'Fname' on Table1, the trigger is fire and update 'Fname' Table2. Thanks in advance...

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    creat trigger mytrigger after update of fname on table1 referencing old as o new as n defaults NULL for each row mode db2sql <what you want to do goes here>

    You should read the SQL Reference Manual.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts