db2 数据 对象备份
CREATE OR REPLACE FUNCTION RSPDB.F_GETROUNDOF32()specific F_GETROUNDOF32
LANGUAGE SQL
RETURNS varchar(32)
BEGIN atomic
declare v_branch_id_rspvarchar(32);
set v_branch_id_rsp = (SELECTsubstr(max
(branch_id),1,24) || to_char(floor(RAND() * 89999999 + 10000000))from SYS_branch_info);
return v_branch_id_rsp;
END
GO
页:
[1]