SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
2-134
Considerations for CREATE TRIGGER
triggered-SQL-statement
is the SQL statement to be performed when this trigger is activated.
searched-update-statement
is an update statement to be performed when the AFTER trigger is activated.
searched-delete-statement
is a delete statement to be performed when the AFTER trigger is activated.
call-statement
is a CALL statement to be performed when the AFTER trigger is activated.
This support is available from SQL/MX Release 3.2.
insert-statement
is an insert statement to be performed when the AFTER trigger is activated.
signal-statement
is a statement to be sent to the SIGNAL statement.
set-new-statement
is an assignment statement that can be used as a BEFORE trigger action to
assign values to transition variables representing columns in the subject table
modified by the triggering action.
quoted-sqlstate
is the five-digit SQLSTATE to be passed to SIGNAL. Use the GET DIAGNOSTICS
command to retrieve quoted-string-expr (as message-text) and
quoted-sqlstate.
quoted-string-expr
is a string expression.
Considerations for CREATE TRIGGER
Triggers support up to 16 levels of recursion. Triggers have their own namespace.
SHOWDDL for a table displays the DDL CREATE text for all triggers defined on that
table. The LIKE option of CREATE TABLE ignores triggers.
Triggers and Utilities

The DUP utility does not duplicate triggers.