Re: SQLLDR80 -- WHY IS THERE AN ERROR?
From: Joe Sugden <jsugden_at_netmeg.no.spam.net>
Date: Thu, 21 Oct 1999 20:45:48 GMT
Message-ID: <0YKP3.2376$hK6.125846_at_monger.newsread.com>
^R
Received on Thu Oct 21 1999 - 22:45:48 CEST
Date: Thu, 21 Oct 1999 20:45:48 GMT
Message-ID: <0YKP3.2376$hK6.125846_at_monger.newsread.com>
I figured out why! There needs to be an extra carrage return after the last
column.
I know this seems dumb, but I didn't realize I had been doing that in the
past.
Example of what works:
load data^R
infile 'filename.txt'^R
badfile 'filename.bad'^R
append^R
into table example.table_name^R
fields terminated by ';'^R
^R
(col1,^R
col2,^R col3,^R col4)^R <<--------------------Include this to make extra line
^R
Received on Thu Oct 21 1999 - 22:45:48 CEST