trigger

[Veaceslav Chicu]

Hello,

how can I do that in derby?:
CREATE TRIGGER acc.ins_doc NO CASCADE BEFORE INSERT ON acc.doc
        REFERENCING NEW AS N
        FOR EACH ROW MODE DB2SQL
WHEN(
        SELECT FROM period
                WHERE state='O' AND
                N.cdate BETWEEN date_start AND date_end
) SIGNAL SQLSTATE 'ERRCODE' ('ERR MESSAGE')
@

another question, can I have 2 or more insert/update statements in after
trigger? how I do?
begin atomic
        update 1;
        update 2;
end
@

thank you,
Slavic