Question

db2导出表的时候报错

运行这句语句：
db2 "export to $HOME/update/20131028/CCS_FEE_PARA .txt of del select * from CCS_FEE_PARA "

结果报错：
SQL0104N An unexpected token ".txt" was found following "<identifier>".
Expected tokens may include: "OF". SQLSTATE=42601

不知道为什么错。

Answer 1

文件名中间有个空格 $HOME/update/20131028/CCS_FEE_PARA .txt
$HOME/update/20131028/CCS_FEE_PARA 与 .txt之间多了一个空格

Answer 2

db2 "EXPORT TO A.txt OF DEL SELECT * FROM BSFC4.A where account_id=1"
我这样导出来了
你直接进入20131028 目录之后 直接导出
db2 "export to CCS_FEE_PARA .txt of del select * from CCS_FEE_PARA "

Answer 3

换一个导出的文件名试一下