我现在想导出表tbl_org1中的数据,命令如下:
db2 export to /aa/cc.del of del select * from tbl_org1
命令执行后提示如下:
SQL3104N The Export utility is beginning to export data to file
"/aa/cc.del".
SQL3001C An I/O error (reason = "sqlofopn -2079391743") occurred while
opening the output file.
SQL3105N The Export utility has finished exporting "0" rows.
请高手指点一下,这是什么原因,谢谢!
------最佳解决方案--------------------------------------------------------
db2 export to cc.del of del select * from tbl_org1
------其他解决方案--------------------------------------------------------
-104是语法错误,你的select语句不对吧,把你的导出语句贴出来
------其他解决方案--------------------------------------------------------
目录下有权限吗?
------其他解决方案--------------------------------------------------------
有权限的,权限也修改了。
------其他解决方案--------------------------------------------------------
aa这个目录有吗? 看提示 通常就是文件和目录的问题
------其他解决方案--------------------------------------------------------
aa目录是我自己建的,有;cc.del开始也建立了,但是提示错误,现在把cc.del删除了
------其他解决方案--------------------------------------------------------
aa的具体位置? 如果不加aa这个目录路径 而在当前目录正常吗?
------其他解决方案--------------------------------------------------------
刚才试了这种方法还是不行,提示如下:
SQL3022N An SQL error "-104" occurred while processing the SELECT string in
the Action String parameter.
SQL0104N An unexpected token "bin" was found following "select aa bak ".
Expected tokens may include: "FROM". SQLSTATE=42601
------其他解决方案--------------------------------------------------------
问题已解决,正确的SQL语句是:
db2 export to cc.del of del "select * from tbl_org1"
谢谢大家的热心帮助!