新手
受系统和用户的限制,现在能做的操作: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是什么?笔误?