mysql函数转db2报错translator runtime error

[Zhaihuafei105]

使用IMB MTK(Migration Toolkit)将mysql转成db2脚本时报错，定位到这一行 select count(BRH_ID) into re_count from IM_BRANCH where BRH_PARENTID=v_id and BRH_FLAG=1;，请大家帮忙看看错误原因，谢谢！
DELIMITER $$

USE `ezecdb`$$

DROP FUNCTION IF EXISTS `is_parent_brhid`$$

CREATE DEFINER=`root`@`%` FUNCTION `is_parent_brhid`(v_id VARCHAR(36)) RETURNS VARCHAR(10) CHARSET utf8
BEGIN
DECLARE re_count VARCHAR(10);
SELECT COUNT(BRH_ID) INTO re_count FROM IM_BRANCH WHERE BRH_PARENTID=v_id;
RETURN re_count ;
END$$

DELIMITER ;