[DB2 ] 資料無法成功匯入DB2中
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)
→
10/26 13:30, , 1F
10/26 13:30, 1F