db2cmd -i
db2
connect to bras user bras using 888888
db2 "export to D:\sqlldr\data\20091207\fhdgckfhz.del of del select * from BRAS.FHDGCKFHZ"
db2 "export to D:\sqlldr\data\20091207\fhdgckmxz.del of del select * from BRAS.FHDGCKMXZ"
db2 "export to D:\sqlldr\data\20091207\fhdkfhz.del of del select * from BRAS.FHDKFHZ"
connect reset
------解决方案--------------------------------------------------------
去掉db2这句试试
------解决方案--------------------------------------------------------
db2cmd -i
db2 connect to bras user bras using 888888
db2 "export to D:\sqlldr\data\20091207\fhdgckfhz.del of del select * from BRAS.FHDGCKFHZ"
db2 "export to D:\sqlldr\data\20091207\fhdgckmxz.del of del select * from BRAS.FHDGCKMXZ"
db2 "export to D:\sqlldr\data\20091207\fhdkfhz.del of del select * from BRAS.FHDKFHZ"
connect reset
这样试试
------解决方案--------------------------------------------------------
------解决方案--------------------------------------------------------
哦,对,最后要断开连接
------解决方案--------------------------------------------------------
db2start,数据库就启动了,关闭窗口,还是启动了。
你把
db2 "export to D:\sqlldr\data\20091207\fhdgckfhz.del of del select * from BRAS.FHDGCKFHZ"
db2 "export to D:\sqlldr\data\20091207\fhdgckmxz.del of del select * from BRAS.FHDGCKMXZ"
db2 "export to D:\sqlldr\data\20091207\fhdkfhz.del of del select * from BRAS.FHDKFHZ"
这些去掉,看看是否还有错误。
------解决方案--------------------------------------------------------
分步执行,
db2cmd -i
db2 connect to bras user bras using 888888
db2 "export to D:\sqlldr\data\20091207\fhdgckfhz.del of del select * from BRAS.FHDGCKFHZ"
结果如何
------解决方案--------------------------------------------------------
你在BAT中加入
CD DB2目录
试试
------解决方案--------------------------------------------------------
你把
db2 connect to bras user bras using 888888
db2 "export to D:\sqlldr\data\20091207\fhdgckfhz.del of del select * from BRAS.FHDGCKFHZ"
db2 "export to D:\sqlldr\data\20091207\fhdgckmxz.del of del select * from BRAS.FHDGCKMXZ"
db2 "export to D:\sqlldr\data\20091207\fhdkfhz.del of del select * from BRAS.FHDKFHZ"
db2 connect reset
这些写成一个bat文件,XXX.bat
然后在命令行里直接执行
db2cmd -i XXX.bat
就可以了。