CREATE or replace TRIGGER tr_before_INSERT
no cascade before INSERT ON tableA
REFERENCING NEW AS NEW FOR EACH ROW MODE DB2SQL
TRGR:
BEGIN
DECLARE v_name VARCHAR(50);
DECLARE v_count INTeger;
SET (v_count)
= (SELECT COUNT(*) FROM tableB WHERE id = new.id);
if v_count > 0 then
SET (v_NAME)
= (SELECT NAME FROM tableB WHERE id = new.id);
set new.name = v_name ;
else
LEAVE TRGR;
end if;
END TRGR