A transition-variable must not be identified more than once in the same SET transition-variable statement.
The data type of each transition-variable must be compatible with its corresponding result column. Values are assigned to transition-variables according to the assignment rules to a column. For more information see Assignments and comparisons.
An expression may contain references to OLD and NEW transition-variables. If the CREATE TRIGGER statement contains both OLD and NEW clauses, references to transition-variables must be qualified by the correlation-name.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.