Re: sqlldr question: data continue by "\"

There is a clause CONTINUEIF LAST="\\" which you might want to use. However, sqlldr will not strip the "\" from your line.

Maybe you are better off using the continueif this clause .. and change the way you receive your datafile.

Anurag

"Ed Wong" <ewong_at_mail.com> wrote in message news:a5ae1554.0208131031.724e274b_at_posting.google.com...
> I have a flat file delimited by "tab" and I need to load it into a
> three-column table where the 3rd column is a clob. The problem is the
> 3rd colum in the flat file is continue by "\" (see below). How do I
> get this data in using sqlldr? I tried (continueif this = "\") but
> appearantly sqlldr doesn't like it.
>
> Thanks in advance.
> ewong
>
> 1 IPR000001 Kringles are autonomous structural domains,
> found throug
> hout the blood clotting and fibrinolytic proteins.\
> Kringle domains are believed to play a role in binding mediators
> (e.g., membrane
> s,\
> [<a href="http://www.ncbi.nlm.nih.gov/htb
> in-post/Entrez/query?uid=84208845&form=6&db=m&Dopt=b">MEDLINE:
> 84208845</a>], [<
> a href="http://www.ncbi.nlm.nih.gov/htbin-post/Entrez/query?uid=90219023&form=6&
> db=m&Dopt=b">MEDLINE: 90219023</a>]. \
> <img src=http://www.sange
> r.ac.uk/Software/Pfam/gifs/betachar.gif width=12 height=10>-sheet.
> They are foun
> d in a varying number of copies, in some serine proteases and\
> plasma proteins.\
> \
>
> control file:
> load data
> infile file.dat"
> into table table_name
> fields terminated by X'09'
> trailing nullcols
> (
> auto_interpro integer external,
> interpro_id char,
> interpro_abstract char)
Received on Wed Aug 14 2002 - 03:55:48 CEST