DB2 循环 ,导入, Reorg

来源:互联网 发布:windows彩蛋星球大战 编辑:程序博客网 时间:2024/06/01 23:17



http://blog.itpub.net/14285854/viewspace-683155/


http://blog.csdn.net/innodyz/article/details/50132275


http://www.cnblogs.com/BradMiller/archive/2013/07/18/3198087.html


++++++++++++++++


CREATE OR REPLACE PROCEDURE TestLoad ()
    DYNAMIC RESULT SETS 1
P1: BEGIN

declare i integer default 1;

while i<10000 do
set i=i+1;
 call sysproc.admin_cmd('load from (select * from HARDWARE_SUPPORT_METRICS_BASE333) of cursor insert into HARDWARE_SUPPORT_METRICS_BASE222 nonrecoverable');
end while;



END P1

0 0
原创粉丝点击