DB2测试脚本——创建触发器

create table A (id varchar(5),name varchar(30));

create table B (id varchar(5),name varchar(30));

CREATE TRIGGER tri_insert 
AFTER INSERT ON A
REFERENCING NEW AS N 
FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC
    INSERT INTO B(ID,NAME) VALUES(N.ID,N.NAME );
END