Figure 5

Using the SET statement

CREATE TRIGGER order_completion
BEFORE INSERT orders
REFERENCING NEW AS n
FOR EACH ROW MODE DB2ROW
BEGIN
SET n.ord_state = UPPER(n.state);
CALL GenOrderNumber(n.ord#);
END