CREATE FUNCTION com.fn_zbcmcode(vcdgroupid VARCHAR(5), vcdid VARCHAR(15))
RETURNS VARCHAR(500)
BEGIN ATOMIC
DECLARE scdnm VARCHAR(500);
SET scdnm = (SELECT a.cdnm cdnm
FROM COM.ZBCMCODE a
WHERE a.cdgrupid = vcdgroupid
AND a.cdid = vcdid);
RETURN scdnm;
END;
이걸 실행하면
ERROR [42501] [IBM][DB2/HPUX-IA64] SQL0551N "COMU01" does not have the privilege to perform operation "CREATE FUNCTION" on object "COM.FN_ZBCMCODE". LINE NUMBER=14. SQLSTATE=42501
이런 오류가 나는데 고수분들의 조언 부탁드립니다. |