Create Trigger window -- Fields and controls

• If the SQL contains a single statement, you do not need the BEGIN ATOMIC and END keywords.
• If you type multiple SQL statements between the BEGIN ATOMIC and END keywords, then you must end each statement with a semicolon(;) or an exclamation point (!).
• The following SQL statements are allowed, depending on whether you selected the Before or the After radio button on the Trigger page:

SQL statement	Before	After
fullselect	X	X
CALL	X	X
SIGNAL SQLSTATE	X	X
VALUES	X	X
SET transition variable	X
INSERT		X
DELETE (searched)		X
UPDATE (searched)		X