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