I’m trying to create a db 2 trigger and I need to explicitly set the terminator trigger in my sql statement. The following is my changeset. Can someone please assist? If this is a bug, can someone give me some help on where to fix it? Thanks
–#SET TERMINATOR /
create trigger test_insert_trg
after insert on test
referencing new as newdata
for each row
mode DB2SQL
begin atomic
insert into HIST
(
ID,
TEST_NR,
TEST_NM,
)
values(
newdata.ID,
newdata.TEST_NR,
newdata.TEST_NM,
);
end
/