Try OpenEdge Now
skip to main content
SQL Development
Stored Procedures and Triggers : Working with triggers : Creating triggers
 

Creating triggers

Use the SQL CREATE TRIGGER statement to create a trigger. This is the syntax for the CREATE TRIGGER statement:
CREATE TRIGGER [owner_name.]trigname{ BEFORE | AFTER }{ INSERT | DELETE | UPDATE [ OF (column_name[ , ...])]} ON table_name[ REFERENCING { OLDROW [ ,NEWROW ]| NEWROW [ ,OLDROW ]}][ FOR EACH { ROW | STATEMENT }][ IMPORT
java_import_clause] BEGIN
java_snippet END