最近在执行db2数据库导库的时候,执行表结构报错。
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 "ROW" was found following "RSPACE1" ORGANIZE
BY". Expected tokens may include: "END-OF-STATEMENT". SQLSTATE=42601
出现此问题的原因是从版本10.5导入版本9.7才会产生的。ORGANIZE BY ROW是DB2 V10.5的新特性
https://www.ibm.com/developerworks/cn/data/library/techarticle/dm-1304whatsnewdb2105/
解决办法:去掉sql中的ORGANIZE BY ROW
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 "INCLUDE NULL KEYS" was found following "ID"
ASC) COMPRESS NO". Expected tokens may include: "<space>". SQLSTATE=42601
COMPRESS NO
INCLUDE NULL KEYS ALLOW REVERSE SCANS;
出现此问题的原因是从版本10.5导入版本9.7才会产生的。ORGANIZE BY ROW是DB2 V10.5的新特性
解决办法:去掉sql中的
COMPRESS NO
INCLUDE NULL KEYS ALLOW REVERSE SCANS;