CREATE OR REPLACE FUNCTION RSPDB.F_GETROUNDOF32 ()
specific F_GETROUNDOF32
LANGUAGE SQL
RETURNS varchar(32)
BEGIN atomic
declare v_branch_id_rsp varchar(32);
set v_branch_id_rsp = (SELECT substr(max
(branch_id),1,24) || to_char(floor(RAND() * 89999999 + 10000000)) from SYS_branch_info);
return v_branch_id_rsp;
END
GO
specific F_GETROUNDOF32
LANGUAGE SQL
RETURNS varchar(32)
BEGIN atomic
declare v_branch_id_rsp varchar(32);
set v_branch_id_rsp = (SELECT substr(max
(branch_id),1,24) || to_char(floor(RAND() * 89999999 + 10000000)) from SYS_branch_info);
return v_branch_id_rsp;
END
GO