CREATE PROCEDURE ADMINISTRATOR.load_test()
LANGUAGE SQL
BEGIN
LANGUAGE SQL
BEGIN
declare sql1 varchar(200);
declare sql2 varchar(200);
set sql1='select * from yh.t';
set sql2='yh.t1';
call sysproc.admin_cmd('load from ('||sql1||') of cursor insert into '||sql2);
declare sql2 varchar(200);
set sql1='select * from yh.t';
set sql2='yh.t1';
call sysproc.admin_cmd('load from ('||sql1||') of cursor insert into '||sql2);
转载于:https://blog.51cto.com/yibingmei/171766