Multiple Triggers

SAP ASE version 16.0 introduces the ability to create multiple triggers, as well as to specify the order in which the triggers are fired after statement execution.

• Creating Multiple Triggers
  Create up to 50 different triggers on a table for each command (insert, update, and delete). Use the new order parameter in the create trigger command, and specify the order that the triggers fire. You can create multiple triggers without an order clause.
• Changing the Order of When a Trigger is Fired
  To change the order in which a trigger is fired, use the or replace option in the create trigger command, using the same trigger name, action, and trigger body as the original trigger, but specifying a new order number.
• Order of Triggers in Merge Statements
  The merge statement fires triggers in a specific order.
• Transactional Behavior with Multiple Triggers
  A rollback transaction executed in a trigger causes rollback of the insert, update, or delete statement that fired the trigger, along with any work performed by the trigger.
• Disabling and Reenabling Triggers
  You can disable and reenable multiple triggers using the alter table command.
• @@trigger_name Global Variable
  The @@trigger_name global variable returns the name of the trigger that is currently executing..