http://www.informix.com/kr/services/cs/tnotes/vol5/QA.html#qa5
를 참조하여 TEST라는 데이터베이스에 cust라는 table을 생성했습니다.
CREATE TABLE cust (customer_num serial,
fname char(15),
lname char(15),
company char(20),
address1 char(20),
address2 char(20),
city char(15),
state char(2),
zipcode char(5),
phone char(18));
데이터파일은 cust.unl
101|Ludwig|Pauli|All Sports Supplies|213 Erstwild Court||Sunnyvale|CA|94086|408-789-8075|
102|Carole|Sadler|Sports Spot|785 Geary St||San Francisco|CA|94117|415-822-1289|
103|Philip|Currie|Phil's Sports|654 Poplar|P. O. Box 3498|Palo Alto|CA|94303|415 -328-4543|
104|Anthony|Higgins|Play Ball!|East Shopping Cntr.|422 Bay Road|Redwood City|CA| 94026|415-368-1100|
105|Raymond|Vector|Los Altos Sports|1899 La Loma Drive||Los Altos|CA|94022|415-776-3249|
command 파일은 cust.cmd
file cust.unl delimiter '|' 10;
insert into cust;
실행은
$) dbload -d stores7 -c cust.cmd -l cust.err -e 100 -n 100
실행을하면 TEST 데이터베이스에 row가 하나도 insert 안됩니다.
error 파일내용은 -------------------------------------
In INSERT statement number 1 of raw data file cust.unl.
Row number 1 is bad.
101|Ludwig|Pauli|All Sports Supplies|213 Erstwild Court|abc|Sunnyvale|CA|94086|408-789-8075| ...
The # of fields in the load file does not match the # on the FILE line
In INSERT statement number 1 of raw data file cust.unl.
Row number 2 is bad.
||||||||||
Reached unexpected end of line while reading field
In INSERT statement number 1 of raw data file cust.unl.
Row number 3 is bad.
102|Carole|Sadler|Sports Spot|785 Geary St|bbb|San Francisco|CA|94117|415-822-1289| ...
The # of fields in the load file does not match the # on the FILE line
In INSERT statement number 1 of raw data file cust.unl.
Row number 4 is bad.
||||||||||
Reached unexpected end of line while reading field
In INSERT statement number 1 of raw data file cust.unl.
Row number 5 is bad.
103|Philip|Currie|Phil's Sports|654 Poplar|P. O. Box 3498|Palo Alto|CA|94303|415 -328-4543| ...
The # of fields in the load file does not match the # on the FILE line
In INSERT statement number 1 of raw data file cust.unl.
Row number 6 is bad.
||||||||||
Reached unexpected end of line while reading field
In INSERT statement number 1 of raw data file cust.unl.
Row number 7 is bad.
104|Anthony|Higgins|Play Ball!|East Shopping Cntr.|422 Bay Road|Redwood City|CA| 94026|415-368-1100| ...
The # of fields in the load file does not match the # on the FILE line
#################################
인포믹스를 시작한지 얼마되지 않아서 여러가지 시도를 해보았지만 어떻게 error를 잡아야 할지 난감합니다. 제 컴에서만 이런게 아니고 서버용으로 쓰고있는 인포믹스도 이모양입니다.
그리고 dbaccess에서 sql 쿼리를 실행해도 에러가 자꾸납니다.
load from 'data.file' insert into test;
846:number of values in load file is not equal to number of columns.
이런 메세지가 자꾸나옵니다. <무엇이 잘못됬는지?>
TEXT file을 DB에 집어넣는 방법있으면 좀가르켜주세요
프로잭트를 진행해야하는데 진도가 안나가는군요
*****도와 주세요********
|