作者sask (sask)
看板Database
标题[DB2 ] 资料无法成功汇入DB2中
时间Mon Oct 25 18:05:28 2010
DBMS: DB2/LINUXX8664 9.7.0
我有一笔资料如下:
"1","巴陵桥","121.378639","24.680556"
所有的资料都被""包覆起来
当我想用下列LOAD指令把资料汇入DB2资料库时
IMPORT FROM 111.txt OF DEL MODIFIED BY CHARDEL"" COLDEL, CODEPAGE=1208
INSERT INTO mitac.poi_igogo (ENT_SHARED_ID, ENT_NAME, COORD_LON, COORD_LAT)
其中ENT_SHARED_ID为INTEGER, ENT_NAME为VARCHAR, COORD_LON和LCOORD_LAT为DOUBLE
会出现下列错误讯息:
SQL3119W The field value in row "1" and column "1" cannot be converted to an
INTEGER value. A null was loaded.
SQL3121W The field value in row "1" and column "3" cannot be converted to a
FLOAT value. A null was loaded.
SQL3121W The field value in row "1" and column "4" cannot be converted to a
FLOAT value. A null was loaded.
请问除了更改资料库的类型外
有甚麽方法可以将数值成功汇入到DB2中呢? 感谢~
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 220.130.36.82
※ 编辑: sask 来自: 220.130.36.82 (10/25 18:06)
1F：→ mmm951:export资料使用IXF然後再做import呢? 10/26 13:30