DB2 FUNCTION 함수 사용

CREATE FUNCTION get_SubMenuCnt (pmenu_id VARCHAR(6), prole_id VARCHAR(6) )
 RETURNS INTEGER
 LANGUAGE SQL

 BEGIN ATOMIC
       DECLARE subMenuCnt INTEGER DEFAULT 0;
       SET subMenuCnt =(SELECT COUNT(*) FROM TGA_MENU WHERE UPPR_MENU_ID= pmenu_id  AND ROLE_ID = prole_id);
     RETURN subMenuCnt;
 END;