DB2.Funciton - 나이구하기

[ DB2.Funciton - 나이구하기 ]

 

* 사원의 나이 구하기 [현재일자,생일]*

 

SET SCHEMA SBSINST;

 

SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","SBSINST";

 

CREATE FUNCTION CMB.GET_AGES

 (ASCURRDATE VARCHAR(8),

  ASBIDD VARCHAR(8)

 )

  RETURNS VARCHAR(3)

  SPECIFIC CMB.GET_AGES

  LANGUAGE SQL

  NOT DETERMINISTIC

  READS SQL DATA

  STATIC DISPATCH

  CALLED ON NULL INPUT

  EXTERNAL ACTION

  INHERIT SPECIAL REGISTERS

  BEGIN ATOMIC

    DECLARE vAGE varchar(3);

    DECLARE I_CUR_YEAR INTEGER ;

    DECLARE I_OLD_YEAR INTEGER ;

    SET I_CUR_YEAR = INT(SUBSTR(asCURRDATE,1,4));

    SET I_OLD_YEAR = INT(SUBSTR(asBIDD,1,4));

    SET vAGE = CHAR(I_CUR_YEAR - I_OLD_YEAR);

    IF vAGE IS NULL THEN

      SET vAGE = '';

    END IF;

    RETURN vAGE;

  END;