DB2触发器的创建以及IF ELSEIF的使用

最近做项目时涉及到需求的修改，要求在向员工信息表插入数据的同时，也要在退休表里插入相应数据，因此

做了一个触发器，其中用到IF ELSEIF 来进行条件判断，在此记录以下。

CREATE TRIGGER INSERT

AFTER  INSERT  ON EMPLOYEE  REFERENCING  NEW AS n  
FOR EACH ROW  MODE DB2SQL
BEGIN ATOMIC

IF  n.C_EMPLOYEESTATUS=4 AND n.C_BASESTATUS='4_1'
THEN
INSERT INTO RETIRE
(C_OID_RETIRE,C_STAFFRECORDID,C_EMPOID,C_RETIRETYPE,C_OPERATOR,C_OPERATETIME)
VALUES((SELECT nvl(max(C_OID+1),1)  FROM TB_INF_EMPLOYEE),(SELECT nvl(max(C_OID+1),1)  FROM EMPLOYEE),
n.C_EMPLOYEEID,1,n.C_OPERATOR,n.C_OPERATETIME);

ELSEIF n.C_EMPLOYEESTATUS=4 AND n.C_BASESTATUS='4_2'
THEN
INSERT INTO RETIRE
(C_OID_RETIRE,C_STAFFRECORDID,C_EMPOID,C_RETIRETYPE,C_OPERATOR,C_OPERATETIME)
VALUES((SELECT nvl(max(C_OID+1),1)  FROM TB_INF_EMPLOYEE),(SELECT nvl(max(C_OID+1),1)  FROM TB_INF_EMPLOYEE),
n.C_EMPLOYEEID,1,n.C_OPERATOR,n.C_OPERATETIME);

END IF;
END;