SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-211
SET Statement
SET Statement
Considerations for SET statement
The SET statement is used with BEFORE triggers to assign values to variables
representing columns in the SQL/MX table to be modified by the triggering action.
correlation-name
is the name of the new row that correlates to the row to be modified.
column-name
is the name of the new column that correlates to the column to be modified.
value-expression
is any valid SQL expression.
Considerations for SET statement
The SET statement can appear only as an action of a BEFORE trigger. The left side of
the assignment can specify only a column in the correlation name of the new row. The
right side of the assignment can be any valid SQL expression (in particular, it can
include subqueries).
In a BEFORE-type trigger action, any column can be updated by SET, including
primary and clustering key columns.
SET correlation-name.column-name = value-expression;