Re: SQLLoader: Tough question

From: no spam <no_at_spam.com>
Date: Thu, 03 Feb 2000 19:51:32 GMT
Message-ID: <8%km4.1761$zr1.5181438@news.magma.ca>

In short NO.

Some additional points that might help.

Sqlldr allows a wide variety of delimiters but you have to use one that is not contained in the data you are loading. The loader file must have this line to use " as a delimter enclosed by ' " '
If you cannot get them to change it to this enclosed by " ' "
Then your only option would be to use ' instaed of " in you data

EnderW wrote in message <87c6bl$dve$1_at_nnrp1.deja.com>...
>Hi,
> this might not be a tough question but it is from my end. In one
>sqlldr file, I have " and these are accepted by the sqlloader as the
>ending of field. They are not. Is there an escape character I can put
>in front of those '"' so that they will not be treated as field
>delimiters but part of the field. Thanks
>
>
> Note. I cannot change the sqlldr control file.
>
>--
>Ender Wiggin
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Thu Feb 03 2000 - 13:51:32 CST