--Create insert trigger
CREATE TRIGGER Insert_PROJECTIONS 
AFTER INSERT ON PROJECTIONS 
REFERENCING NEW AS N FOR EACH ROW MODE DB2SQL 
BEGIN ATOMIC 
  INSERT INTO P_Audit VALUES (N.PROJECTION_ID, 
                              N.PROJECTION_NAME,
                              N.PROJECTION_TYPE, 
                              N.SPHEROID_CODE, 
                              N.PROJECTION_UOM, 
                              N.ZONE_CODE,
                              CURRENT TIMESTAMP); 
END

