DB2中admin_cmd执行load

CREATE PROCEDURE ADMINISTRATOR.load_test()
  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);

END;
本文来自: IXPUB技术社区( www.ixpub.net) 详细出处参考： http://www.ixpub.net/thread-858238-1-1.html

转载于:https://blog.51cto.com/yibingmei/171766