为什么db2 load 老是提示SQL3304N 表不存在
我写了两个bat,第一个import.bat:
db2cmd -i importnew.bat
第二个importnew.bat
::连接数据库
db2 connect to bras user bras using bras
set year=%date:~0,4%
set month=%date:~5,2%
set dat=%date:~8,2%
::保存导出数据的目录名
set folderpath=D:\sqlldr\data\
::当前日期
set curdate=%year%%month%%dat%
set exportpath=%folderpath%%curdate%
::判断要导出目录下的文件是否存在
if not exist %exportpath% md %exportpath%
db2 load from "%exportpath%\fhdgckfhz.del" of del MESSAGES "D:\1.log" replace into bras.fhdgckfhz;
db2 load from "%exportpath%\fhdkfhz.del" of del MESSAGES "D:\1.log" replace into bras.fhdkfhz;
db2 load from "%exportpath%\fhdsdqfhz.del" of del MESSAGES "D:\1.log" replace into bras.fhdsdqfhz;
db2 load from "%exportpath%\fhdshqfhz.del" of del MESSAGES "D:\1.log" replace into bras.fhdshqfhz;
db2 load from "%exportpath%\fhgjfhz.del" of del MESSAGES "D:\1.log" replace into bras.fhgjfhz;
db2 load from "%exportpath%\fhnbz.del" of del MESSAGES "D:\1.log" replace into bras.fhnbz;
db2 load from "%exportpath%\fhzqfhz.del" of del MESSAGES "D:\1.log" replace into bras.fhzqfhz;
db2 load from "%exportpath%\djsstc.del" of del MESSAGES "D:\1.log" replace into bras.djsstc;
db2 load from "%exportpath%\djszxtctdxx.del" of del MESSAGES "D:\1.log" replace into bras.djszxtctdxx;
db2 load from "%exportpath%\djzflrfhls.del" of del MESSAGES "D:\1.log" replace into bras.djzflrfhls;
db2 load from "%exportpath%\fhdgckmxz.del" of del MESSAGES "D:\1.log" replace into bras.fhdgckmxz;
db2 load from "%exportpath%\fhdkmxz.del" of del MESSAGES "D:\1.log" replace into bras.fhdkmxz;
db2 load from "%exportpath%\fhdsdqmxz.del" of del MESSAGES "D:\1.log" replace into bras.fhdsdqmxz;
db2 load from "%exportpath%\fhdshqmxz.del" of del MESSAGES "D:\1.log" replace into bras.fhdshqmxz;
db2 load from "%exportpath%\fhgjmxz.del" of del MESSAGES "D:\1.log" replace into bras.fhgjmxz;
db2 load from "%exportpath%\fhnbzmxz.del" of del MESSAGES "D:\1.log" replace into bras.fhnbzmxz;
db2 load from "%exportpath%\GGBZ.del" of del MESSAGES "D:\1.log" replace into bras.GGBZ;
db2 load from "%exportpath%\GGCKLL.del" of del MESSAGES "D:\1.log" replace into bras.GGCKLL;
db2 load from "%exportpath%\GGCZY.del" of del MESSAGES "D:\1.log" replace into bras.GGCZY;
db2 load from "%exportpath%\GGCZYBZ.del" of del MESSAGES "D:\1.log" replace into bras.GGCZYBZ;
db2 load from "%exportpath%\GGDKLL.del" of del MESSAGES "D:\1.log" replace into bras.GGDKLL;
db2 load from "%exportpath%\GGGJ.del" of del MESSAGES "D:\1.log" replace into bras.GGGJ;
db2 load from "%exportpath%\GGJGM.del" of del MESSAGES "D:\1.log" replace into bras.GGJGM;
db2 load from "%exportpath%\GGJSZH.del" of del MESSAGES "D:\1.log" replace into bras.GGJSZH;
db2 load from "%exportpath%\GGJYM.del" of del MESSAGES "D:\1.log" replace into bras.GGJYM;
db2 load from "%exportpath%\GGKMZD.del" of del MESSAGES "D:\1.log" replace into bras.GGKMZD;
db2 load from "%exportpath%\GGPZZL.del" of del MESSAGES "D:\1.log" replace into bras.GGPZZL;
db2 load from "%exportpath%\GGXJXMH.del" of del MESSAGES "D:\1.log" replace into bras.GGXJXMH;
db2 load from "%exportpath%\GGKHJLBH.del" of del MESSAGES "D:\1.log" replace into bras.GGKHJLBH;
db2 load from "%exportpath%\GGXTCS.del" of del MESSAGES "D:\1.log" replace into bras.GGXTCS;
db2 load from "%exportpath%\GGYWZLZD.del" of del MESSAGES "D:\1.log" replace into bras.GGYWZLZD;
db2 load from "%exportpath%\GGZYM.del" of del MESSAGES "D:\1.log" replace into bras.GGZYM;
db2 load from "%exportpath%\GGZDFL.del" of del MESSAGES "D:\1.log" replace into bras.GGZDFL;
db2 load from "%exportpath%\LSFLLS.del" of del MESSAGES "D:\1.log" replace into "BRAS "."LSFLLS";
db2 load from "%exportpath%\LSGYLJS.del" of del MESSAGES "D:\1.log" replace into bras.LSGYLJS;
db2 load from "%exportpath%\lslsz.del" of del MESSAGES "D:\1.log" insert into bras.LSLSZ;
db2 connect reset
运行第一个BAT,怎么老是报:SQL3304N 表不存在啊,db2 load 拷贝到DB2CC都可以执行
[解决办法]
你的第一个bat就是用来执行第二bat的？
你应该手动执行以下第二个文件，看看报什么错
[解决办法]
db2 load from "%exportpath%\LSFLLS.del" of del MESSAGES "D:\1.log" replace into "BRAS "."LSFLLS";
倒数第四行，你看着对吗？不应该加引号吧
[解决办法]
既然提示表不存在，那就肯定是有表没有定义，或是模式不对造成的，你自己在好好检查一下吧，通过你的bat看不出来少什么
[解决办法]
合并功能，尝试用一个BAT文件执行。
[解决办法]
其实要调试起来很简单 一句一句执行 到哪句出错就看哪句
