db2函数实现字符串id分割，返回name集合

CREATE FUNCTION "USER_LIST"
(str VARCHAR(5000))
RETURNS VARCHAR(5000)
LANGUAGE SQL
SPECIFIC SQL160831131502600
begin
declare v_start int;
declare v_end int;
declare splitchar varchar(5) default ';';
declare A_CURR_NAME varchar(5000) default '';
declare v_str varchar(50);
set v_start=1;
set v_end=locate(splitchar,str);
while v_end>0 do
set v_str=substr(str,v_start,v_end-v_start);
set v_start=v_end+1;
set v_end=locate(splitchar,str,v_start);
set A_CURR_NAME=A_CURR_NAME||(select splitchar||fd_name from sys_org_element where fd_id=v_str);
end while;
set v_str=substr(str,v_start);
set A_CURR_NAME=A_CURR_NAME||(select splitchar||fd_name from sys_org_element where fd_id=v_str);
return substr(A_CURR_NAME,2);
end

转载于:https://www.cnblogs.com/llmke/p/5826056.html