level 1
o追忆似水流年o
楼主
create PROCEDURE bir.test()
begin
declare varTabName1 varchar(20);
declare varTabName2 varchar(20);
declare cycle_end int default 0;
declare var_sql varchar(2000);
declare cursor1 cursor for select mysql_tabname,db2_tabname from bir.test;
select count(*) into cycle_end from bir.test ;
open cursor1;
fetch cursor1 into varTabName1,varTabName2;
while cycle_end>0 do
set var_sql='load from ''/home/db2inst1/tmp/'||varTabName1||'.txt''of del modified by codepage=1208 replace into'||varTabName2;
execute immediate var_sql;
fetch cursor1 into varTabName1,varTabName2;
set cycle_end=cycle_end-1;
end while;
close cursor1;
end
这是个存储过程目的是将数据导入到表
运行时出错 [Error Code: -454, SQL State: 42723] DB2 SQL Error: SQLCODE=-454, SQLSTATE=42723, SQLERRMC=BIR.TEST, DRIVER=4.13.127
求解答，求帮忙
2014年01月10日 09点01分
1
begin
declare varTabName1 varchar(20);
declare varTabName2 varchar(20);
declare cycle_end int default 0;
declare var_sql varchar(2000);
declare cursor1 cursor for select mysql_tabname,db2_tabname from bir.test;
select count(*) into cycle_end from bir.test ;
open cursor1;
fetch cursor1 into varTabName1,varTabName2;
while cycle_end>0 do
set var_sql='load from ''/home/db2inst1/tmp/'||varTabName1||'.txt''of del modified by codepage=1208 replace into'||varTabName2;
execute immediate var_sql;
fetch cursor1 into varTabName1,varTabName2;
set cycle_end=cycle_end-1;
end while;
close cursor1;
end
这是个存储过程目的是将数据导入到表
运行时出错 [Error Code: -454, SQL State: 42723] DB2 SQL Error: SQLCODE=-454, SQLSTATE=42723, SQLERRMC=BIR.TEST, DRIVER=4.13.127
求解答，求帮忙
