I know that some sql procedure statement I can used in trigger, but I got error, when I try this:
CREATE TRIGGER NEW_TRIG_TEST
AFTER INSERT ON FH04T18
FOR EACH ROW MODE DB2SQL
DECLARE l_proces varchar(50) DEFAULT 'TRIGGER';
DECLARE l_param varchar(50) DEFAULT 'USE';
.....
is it possible to used DECLARE statement in trigger?