Progress
SQL-89
Guide and Reference


Database Triggers

If a table has database triggers defined in the schema, then accessing rows in that table with Progress/SQL statements causes those triggers to execute. Table 3–6 lists the SQL statements that can cause schema triggers to execute.

Table 3–6: SQL Statements and Database Schema Triggers  
SQL Statement
Triggers
DELETE FROM
FIND and DELETE
FETCH
FIND
INSERT INTO
CREATE, ASSIGN, and WRITE
SELECT
FIND
UPDATE
FIND, ASSIGN, and WRITE
UNION
FIND

Schema triggers execute in both interactive SQL and ESQL. You cannot define session triggers in Progress/SQL.

Progress manages SQL write triggers for INSERT and searched UPDATE statements by deferring execution of all write triggers until the entire searched UPDATE or INSERT statement has executed. However, write triggers are a part of the statement’s transaction, so if a trigger fails, the entire searched UPDATE or DELETE statement is undone.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095