hello people,
few days ago I had a problem with a insert trigger for this table:
CODICE DESCRIZION TIPO.

now I would like to create a update trigger, that update/insert the record in ADMIN.ANAMAGA_TMP after an update in my table ADMIN.ANAMAGA
but the problem is that at the begining my column TIPO is empty. I try 4 way:
1)
CREATE TRIGGER ADMIN.REPLICA5 AFTER UPDATE OF CODICE, DESCRIZION, TIPO ON ADMIN.ANAMAGA REFERENCING NEW AS n FOR EACH ROW MODE DB2SQL UPDATE
ADMIN.ANAMAGA_TMP
SET DESCRIZION = n.descrizion,
TIPO = n.TIPO
WHERE
(
( ADMIN.ANAMAGA_TMP.CODICE = n.codice )
AND ( ADMIN.ANAMAGA_TMP.DESCRIZION <> n.descrizion OR ADMIN.ANAMAGA_TMP.TIPO is null )
)//nothing
2)
CREATE TRIGGER ADMIN.REPLICA1 AFTER UPDATE OF CODICE, DESCRIZION, TIPO ON ADMIN.ANAMAGA REFERENCING NEW AS n FOR EACH ROW MODE DB2SQL INSERT INTO
ADMIN.ANAMAGA_TMP
VALUES
(
n.CODICE,
n.DESCRIZION,
n.TIPO
) ////update CODICE, DESCRIZION, but not TIPO

||||||||||||||||more simple

CREATE TRIGGER ADMIN.REPLICA1 AFTER UPDATE OF TIPO ON ADMIN.ANAMAGA REFERENCING NEW AS n FOR EACH ROW MODE DB2SQL INSERT INTO
ADMIN.ANAMAGA_TMP
VALUES
(
n.TIPO
)/////all rows empty

at the end

CREATE TRIGGER ADMIN.REPLICA1 AFTER UPDATE OF TIPO ON ADMIN.ANAMAGA REFERENCING NEW AS n FOR EACH ROW MODE DB2SQL INSERT INTO
ADMIN.ANAMAGA_TMP
(TIPO)
VALUES
(
n.TIPO
)/////nothng


can you help me? thanks