| another problem in sqlloader [message #69122] |
Fri, 02 November 2001 13:29  |
w j
Messages: 4
Registered: November 2001
|
Junior Member |
|
|
the data is:
31, 1, 0.0, 0.0, 0.0, 0.23002, gamma1, 000, 1
31, 1, 0.0, 0.0, 0.0, 0.98073, gamma2, 000, 2
......
________________________________________________
and the control file is:
LOAD data
infile 'testdata.dat'
append
INTO table test
fields terminated by ","
trailing nullcols
(tid, codea, codeb, codec, coded, codee, codef, codeg, codeh)
___________________________________________
sqlloader told me that 27 records inserted,
but when i select * from the table, I found that
just only one record in table: just the first line
in data file: 31, 1, 0.0, 0.0, 0.0, 0.23002, gamma1, 000, 1
could you tell me why? thank you so much!!!!
----------------------------------------------------------------------
|
|
|
|
| Re: another problem in sqlloader [message #69123 is a reply to message #69122] |
Sat, 03 November 2001 04:12  |
Suresh Vemulapalli
Messages: 624
Registered: August 2000
|
Senior Member |
|
|
open log file and you will get more information why records rejected. ( it could be primary key problem or data length of field is not enough)
SURESH
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
