Re: Record delimiter in SqlLoader

TurkBear wrote:

> Hi,
> Is there a way to specify a record delimiter in a Sql Loader input file.
> I can specify the field delimiter with the 'terminated by optionally enclose by' syntax, but how to I tell it
> that the record ends with something other than a CR/LF ( or NewLine) character?
> ( Like a | for instance)
>
> Thanks,
>
>
> -----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
> http://www.newsfeed.com The #1 Newsgroup Service in the World!
> -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----

[Quoted] A typical control file might look like this:

LOAD DATA
INFILE *
INTO TABLE dept
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
(deptno, dname, loc)

Change the fields terminated by to '|'

and you have what you want.

Daniel Morgan Received on Fri Aug 09 2002 - 22:46:24 CEST