CREATE TRIGGER TRI_COLTB_INSERT INSTEAD OF INSERT ON A REFERENCING NEW AS N FOR EACH ROW MODE DB2SQLBEGIN UPDATE A SET NAME = (SELECT NAME FROM B WHERE ID = N.ID) ;END;
