Results 1 to 2 of 2

Thread: Alter trigger

  1. #1
    Join Date
    Oct 2010
    Posts
    94

    Unanswered: Alter trigger

    Hello,

    I am looking to set a timestamp field to current timestamp in an existing update trigger on a z/OS DB2 table. Could you help me with the syntax please to alter the existing trigger to include one more SQL? We are on DB2 v9.1 Z/OS.

    THANKS AS ALWAYS!!!
    -G

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    I don't think it is possible to add an additional sql statement using alter trigger. you have to drop and recreate the trigger.
    If you have more than one trigger for the same operation(insert/update/delete) and you require the triggers to be fired in the same order, then you may have to drop and recreate all those triggers.

    HTH

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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