load “"DUMPFILE" 选项与 "DELPRIORITYCHAR" 选项不兼容”
用的是IBMExtract自动从mysql生成脚本,导入到db2中,在load数据的时候出现了"DUMPFILE" 选项与 "DELPRIORITYCHAR" 选项不兼容"的错误,内容一条也没插进去,但是表结构和主外键都成功导入。
有知道的朋友帮帮忙了,解决立刻给分。
LOAD FROM "C:\output\citytrade_data\db2admin_cmsuser.txt"
OF DEL
MODIFIED BY COLDEL~ ANYORDER USEDEFAULTS KEEPBLANKS CHARDEL"" DELPRIORITYCHAR
DUMPFILE="C:\output\citytrade_dump\db2admin_cmsuser.txt"
METHOD P (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15)
MESSAGES "C:\output\citytrade_msg\db2admin_cmsuser.txt"
REPLACE INTO cmsuser
(
ID,
USERNAME,
NICKNAME,
SEX,
EMAIL,
TELPHONE,
DEPARTMENTID,
BIRTHDAY,
PHOTO,
ADDRESS,
FAVOR,
ISDELETE,
KNOWLEDGE,
SPECIALTY,
ACADEMY
)
STATISTICS YES WITH DISTRIBUTION AND DETAILED INDEXES ALL
COPY NO
INDEXING MODE AUTOSELECT
;
---------------------------------------数据文件
1~"Administrator"~"admin"~0~~~1~~"tradebm/images/photo.jpg"~~~0~~~