读书人

db2导出数据有关问题

发布时间: 2012-03-26 15:46:56 作者: rapoo

db2导出数据问题
新手
受系统和用户的限制,现在能做的操作:export, db2look
现在用DBArtisan导出了库里的表结构,但是耗时太久(近一天),
现在我想导出所有表的数据,用db2move命令时提示如下:

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "END-OF-STATEMENT" was found following
"db2move". Expected tokens may include: "JOIN <joined_table>".
SQLSTATE=42601

backup命令没有权限,大家帮看下怎么导数据啊,最好有sql语句和bin文件两种格式

[解决办法]
EXPORT TO "D:\AAA" OF DEL MESSAGES "D:\BBB" SELECT * FROM TABLE;
不过这种方式只能每次导出一个表的数据
[解决办法]
http://blog.csdn.net/Mr_Bean/archive/2006/11/02/1362400.aspx
[解决办法]
导出数据库的所有表数据 : db2move dbname export
[解决办法]
SQL0104N An unexpected token "END-OF-STATEMENT" was found following "dbmove".

dbmove是什么?笔误?

读书人网 >IBM DB2

热点推荐