Hi,
Try to use CONTINUEIF clause.
--
Dmitry,
www.ispirer.com - Database migration tools and services for Oracle and IBM
DB2.
<Ragini_Khanjee_at_Dell.com> wrote in message
news:C9BAC45B90DDD311BDBE009027B6B6B235DA6A_at_ausxmps103.us.dell.com...
> Hello
> I am trying to sqlload multi column data that is comma delimeted and also
> each column is enclosed in quotes. The problem I am encountering is that
> one of the data columns "call_text" is a varchar2(2000) and contains
control
> characters. I would like to load the data with the control characters as
is
> but am not successful at it. When I sqlload the data and a control
> character is encountered, sqlload think that it is the beggining of a new
> record when infact it's just part of the call_text data. The control
> characters are not always in a specific column nor is there anything about
> the data in that column that's consistent such as beginning with a
specific
> string or number. Also, every record may not always contain a control
> character in that column. So, it varies. Some have it and some don't.
>
> Kindly, would you please direct me as to how to set up the control file to
> load such data.
>
> I would really appreciate your help in this matter as I've tried so many
> different options with no avail. Thank you.
>
> Sincerely
> Ragini_Khanjee_at_dell.com
>
>
>
> --
> Posted from ausxc07.us.dell.com [143.166.99.215]
> via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Mon Feb 26 2001 - 06:02:29 CST
