User's Manual

Usage Anywhere.
Permissions Must have RESOURCE authority and have ALTER permissions on the
table, or must have DBA authority. CREATE TRIGGER puts a table lock on
the table and thus requires exclusive use of the table.
Side effects Automatic commit.
See also “CREATE TRIGGER statement [SQL Remote]” [ASA SQL Reference,
page 423]
“UPDATE statement” on page 378
360