db2从表中export出的数据无法import

jiaanqing

从一个数据表(A)中导出数据"export to 1.txt of del select * from a",大概有20万条数据
然后再导进入B数据表中,B表与A表结构一样,索引一样.
"import from 1.txt of del insert into B"
报错大致是有部分数据非法导入不成功.有几万条数据导不进数据表.

这个问题如何解决呀?
del格式能转换成ixf格式的文件吗

我用"insert into b select * from A"
就可以做.
用ixf格式的也没问题,关键问题是,我已经把表A清空了.现在只剩下.del文件了,杯具.

SQL3114W Some data following "","" in row "6" and column "1" was not loaded.
SQL3125W The character data in row "6" and column "3" was truncated because
the data is longer than the target database column.
SQL3129W The date, time, or timestamp field containing "" "" in row "6"
and column "8" was padded with blanks.
SQL3119W The field value in row "6" and column "24" cannot be converted to an
INTEGER value. A null was loaded.
SQL3128W The field containing "+0000000000106.77" in row "6" and column "27"
was truncated into a DATE field because the data is longer than the database
column.
这是import时报的错误,有高人指点一下吗,把已经导出的del文件转换成ixf格式?

jiaanqing

没人回复啊.

qiubinwei

the data is longer than the target database column
看系统的提示信息
有些数据可能长度超过了定义的吧。