Informix Guide to SQL: Tutorial
Chapter 15: Creating and Using Triggers
Home
Contents
Index
Master Index
New Book
Summary
To introduce triggers, this chapter covers the following topics:
The purpose of each component of the
CREATE TRIGGER
statement
How to create
BEFORE
and
AFTER
triggered actions and how to use them to determine the impact of the triggering statement
How to create a
FOR EACH ROW
triggered action and how to use the
REFERENCING
clause to refer to the values of columns both before and after the action of the triggering statement
The advantages of using SPL routines as triggered actions
How to trace triggered actions if they are behaving unexpectedly
How to generate two types of error messages within a triggered action
Informix Guide to SQL: Tutorial
, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.
