admin_cmd() for load 實(shí)現(xiàn)表間復(fù)制

fuxc_666

我想實(shí)現(xiàn)一個(gè)表中的數(shù)據(jù)通過(guò)cursor復(fù)制到另一個(gè)表中。主要語(yǔ)句如下：

ASSOCIATE RESULT SET LOCATORS(LOC1,LOC2) WITH PROCEDURE fedpro22;
CALL SYSPROC.ADMIN_CMD('ALLOCATE c1 CURSOR FOR RESULT SET LOC1;load from c1 of cursor insert into orafvtta1');
CALL SYSPROC.ADMIN_CMD('ALLOCATE c2 CURSOR FOR RESULT SET LOC2;load from c2 of cursor insert into orafvtta2');


orafvtta1與orafvtta2這兩個(gè)是空表。fedpro22是通過(guò)cursor返回兩個(gè)結(jié)果集的存儲(chǔ)過(guò)程。沒(méi)有報(bào)錯(cuò)。只是orafvtta1與orafvtta2還是空表。不知道這樣寫(xiě)是否能實(shí)現(xiàn)上功能。了解這方面的高手指教，多謝！