Re: sqlloader

From: <ameguerian_at_yahoo.com>
Date: Sun, 18 Oct 1998 14:13:59 GMT
Message-ID: <70ct38$811$1@nnrp1.dejanews.com>

     I am not sure, but I am using this one bellow and it works fine. I can't    see much difference between the two. The only thing I can think of is that    you have a blank line at the end of your file.

LOAD DATA
INFILE *
INTO TABLE TABLE1
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' (

col1,
col2,
col3,
col4,

col5
)
BEGINDATA
2,"Message","X",,"X"
3,"Welcome","","",""

In article <707lbf$dfm$1_at_uranium.btinternet.com>,   "Steve" <steve_at_encite.com> wrote:
> Could somebody please tell me why I keep getting a "partial record found at
> end of datafile" error when using SQLLoader. I have a very simple data file
> such as:-
>
> ABC,DEF
> GHI,JKL
> MNO,PQR
>
> and a control file like:
>
> load data
> infile 'mydata'
> into table test
> fields terminated by ','
> (termcode, termname)
>
> Much thanks
> Steve
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sun Oct 18 1998 - 09:13:59 CDT