(B)0[mtriggered-action-clause =
qwqqqqqqqqqqqq>qqqqqqqqqqqqqqwqk
mq> [4mWITH[m conditional-expr qqj x
lqqqqqqqqqqqqq<qqqqqqqqqqqqqqqj
mq> [4mEXECUTE[m qw> triggered-statement qwqqwqqqqqqqqqq>qqqqqqqqwq>
mqqqqqqqqqqq ; qqqq<qqqqj mq> [4mFOR[m [4mEACH[m [4mRECORD[m j
(B)0[mtriggered-statement =
qwq> store-statement qqqqqqqqqqqqqqqqqqqwq>
tq> [4mFOR[m rse store-statement [4mEND_FOR[m qqu
tq> [4mFOR[m rse erase-statement [4mEND_FOR[m qqu
tq> [4mFOR[m rse modify-statement [4mEND_FOR[m qqu
mq> [4mERROR[m qqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
A triggered action clause consists of a conditional expression
(optional), one or more triggered statements, and a frequency
clause (FOR EACH RECORD). The EXECUTE keyword precedes the
triggered action clause.
1 – rse
A record selection expression that defines which records of which
relations will be affected by the triggered update action. This
rse cannot refer to any host variables.
2 – store-statement
A STORE statement to be initiated by the trigger.
3 – erase-statement
An ERASE statement to be initiated by the trigger.
4 – modify-statement
A MODIFY statement to be initiated by the trigger.
5 – WITH
A conditional expression that describes the optional condition
that must be satisfied before the associated triggered statements
are executed. This expression cannot refer to any host variables.
For more information on Oracle Rdb conditional expressions, ask for
HELP on the top level topic Cond_expr.
6 – FOR_EACH_RECORD
A frequency clause, FOR EACH RECORD (no underscores), determines
whether an action is evaluated once per triggering statement, or
for each record of the subject relation updated by the triggering
statement. If the FOR EACH RECORD clause is not specified, the
triggered action is evaluated only once, and record values are
not available to the triggered action.