Try OpenEdge Now
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
