Mimer SQL Programmer's Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


Triggers


A trigger defines an SQL statement that is to be executed before, after or instead of a specified data manipulation operation on a named table or view.

The execution of the SQL statement can be made conditional on the evaluation of a search condition.

The SQL statement is typically a compound SQL statement, thus allowing a number of SQL statements to be executed by the trigger. The compound SQL statement must be defined as ATOMIC.

Thus, the body of a trigger is similar to the body of a routine and the same constructs may be used within it.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Programmer's Manual TOC PREV NEXT INDEX