Progress
Database Design
Guide


SQL-92 Triggers

A trigger is a procedure that is invoked when certain database events occur. Triggers are used to enforce referential integrity and business rules.

A Java trigger is a Java routine that is executed by a SQL-92 server process when certain database events occur (INSERT, UPDATE, and DELETE) on the trigger’s target table. Triggers use Progress Java classes.

Triggers can be thought of as automatically called stored procedures. Like stored procedures, triggers are stored in the database.

Designing the trigger code consists of writing the Java code that defines what the application does when the user interacts with the user-interface elements. For example, the application might write a particular database record when the user clicks on a particular button. In this case, the trigger code is the code that writes the record when the user clicks on that button.

Java triggers execute on the database server side.


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