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>


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

Original text of this message