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.
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.
Visit the new-look IDUG Website , register to gain access to the excellent content.