Re: sqlloading data that contains newlines
From: <vserg_at_my-deja.com>
Date: Thu, 09 Mar 2000 15:36:40 GMT
Message-ID: <8a8ge8$ki8$1_at_nnrp1.deja.com>
Date: Thu, 09 Mar 2000 15:36:40 GMT
Message-ID: <8a8ge8$ki8$1_at_nnrp1.deja.com>
In article <38B2D0AA.4DD771BD_at_kenan.com>,
Jonah Egenolf <jegenolf_at_kenan.com> wrote:
> Is there a way to load text strings containing newline characters
using
> sqlloader?
>
> I can't figure out how to change the row delimiter.....
>
> Thanks!
>
> - Jonah
>
>
I define row end as <rowend>CRLF.
Try create control file like my:
load data
infile 'POLICY.dat' "str X'3c726F77656e643e0d0a'"
into table POLICY
fields terminated by '<end>'
TRAILING NULLCOLS
(ID_CUST ,
CONDITIONS CHAR(4000),
TERMS CHAR(4000),
REASONS CHAR(4000),
DIRECTIONS CHAR(4000),
PHONE ,
URL ,
EMAIL ,
PACKING )
Sergey Vlasov
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Mar 09 2000 - 16:36:40 CET