Hi
UDB version 8.01.0005
Need help in constructing a trigger, All it does is copies the contents to another table, has to be trigger on insert or update.

My Question
could I have both INSERT and UPDATE trigger in one trigger. Does it work or I need to seperate them.

CREATE TRIGGER NEW_HIRE
AFTER INSERT ON EMPLOYEE
AFTER UPDATE ON EMPLOYEE
FOR EACH ROW MODE DB2SQL
UPDATE COMPANY_STATS SET NBEMP = NBEMP + 1

You need two triggers.

Andy