Re: sqlldr problem

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Mon, 11 Feb 2002 22:07:34 -0000
Message-ID: <3c68479c_1@mk-nntp-1.news.uk.worldonline.com>

Lookat CONTINUEIF

Paul

"Sunil Pant" <spant_at_eline.com> wrote in message news:B9X98.1257$1F2.22083_at_sea-read.news.verio.net...
> I have a control file as below:
>
> load data
> infile 'zprod_rev.dmp'
> append into table zprod_rev
> FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY "*text"(
> reviewid,reviewbody char(64000),rating)
>
> The reviewbody has a lot of carriage returns and sql loader takes each one
> of them as new rows and eventually exceeds the error limits. How do I
tell
> sql loader not to take carriage returns as new rows or define something
like
> *row as row delimiter.
>
> Thanks,
> SP
>
>
Received on Mon Feb 11 2002 - 16:07:34 CST