i should create a trigger that insert the record in ADMIN.ANAMAGA_TMP after an insert in my table ADMIN.ANAMAGA. the db i db2 version 7. can you help me thanks thi is my code:
CREATE TRIGGER ADMIN.REPLICA AFTER INSERT ON ADMIN.ANAMAGA REFERENCING NEW AS n FOR EACH ROW MODE DB2SQL INSERT INTO
but my result in ADMIN.ANAMAGA_TMP in the column CODICE is codice and not a value for example 1223.
anamaga is composed from
CODICE DESCRIZION TIPO
anamaga_temp is equal to anamaga (the some column).
when I insert a new one row in anamaga i would like to insert the row in anamaga_tmp in order to extract only new data.