Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see Why Migrate to InterSystems IRIS?

Event

Specifies the SQL events that will fire this trigger. Required (no default).

Usage

To specify the SQL events that will fire the trigger, use the following syntax:

Trigger name [ Event = sqlevent, Time = AFTER ]
{
   //implementation
}

Where sqlevent is one of the following values:

  • DELETE — this trigger is fired during an SQL DELETE operation.

  • INSERT — this trigger is fired during an SQL INSERT operation.

  • UPDATE — this trigger is fired during an SQL UPDATE operation.

  • INSERT/UPDATE — this trigger is fired during an SQL Insert operation or an SQL UPDATE operation.

  • INSERT/DELETE — this trigger is fired during an SQL Insert operation or an SQL DELETE operation.

  • UPDATE/DELETE — this trigger is fired during an SQL Update operation or an SQL DELETE operation.

  • INSERT/UPDATE/DELETE — this trigger is fired during an SQL INSERT operation, an SQL UPDATE operation, or an SQL DELETE operation.

Details

This keyword specifies the SQL events that will fire the trigger.

Default

There is no default. When you define a trigger, you must specify a value for this keyword.

See Also

Feedback