Hi. I am trying to create a trigger when a table in the DB is updated. (We have an IBM DB2 mainframe database.) I am quite new to creating triggers, so please bear with me. Here is my code:

CREATE TRIGGER FS3DAP08
    NO CASCADE BEFORE UPDATE ON TABLE1
    REFERENCING OLD AS o
            NEW AS n
    FOR EACH ROW MODE DB2SQL
    BEGIN ATOMIC
     INSERT INTO TABLE2 (F1, F2, F3, F4, F5, F6, F7)
     VALUES
    (o.F1, o.F2, o.F3, USER, CURRENT TIMESTAMP, 'UPDATE', '1');
     INSERT INTO TABLE2 (F1, F2, F3, F4, F5, F6, F7)
     VALUES
    (o.F1, o.F2, o.F3, USER, CURRENT TIMESTAMP, 'UPDATE', '2');
        END
;

Any suggestions or help would be greatly appreciated. Thanks!

rrr24,
I don't think you are in the right topic. This topic forum is for MS Access Database not IBM DB2. Also, there are no triggers in MS Access Database.
John