Informix Guide to SQL: Tutorial
Chapter 15: Creating and Using Triggers
Home
Contents
Index
Master Index
New Book
Creating and Using Triggers
When to Use Triggers
How to Create a Trigger
Assigning a Trigger Name
Specifying the Trigger Event
Defining the Triggered Actions
A Complete CREATE TRIGGER Statement
Using Triggered Actions
Using BEFORE and AFTER Triggered Actions
Using FOR EACH ROW Triggered Actions
Using the REFERENCING Clause
Using the WHEN Condition
Using SPL Routines as Triggered Actions
Passing Data to an SPL Routine
Using SPL Procedure Language
Updating Nontriggering Columns with Data from an SPL Routine
Tracing Triggered Actions
Generating Error Messages
Applying a Fixed Error Message
Generating a Variable Error Message
Summary
Informix Guide to SQL: Tutorial
, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.
