Re: Row Terminator in SQL*Loader

Use continueif...:

continueif this (n) = '?'

Where n is the numeric position of your terminator character and ? is your terminator character.
--
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
(Original email address is spam-blocked.)

Peter Giannopoulos <petergi_at_generation.net> wrote in article <35C21B3A.FD335052_at_generation.net>...
> I'm having the same problem, and would like to know as well when you
> find out.
> Also what oracle datatype did you choose to store the data from and SQL
> Server text field?
>
>
> Thanks.
>
>
>
> Shalabh Bhatnagar wrote:
> >
> > Hi Anybody,
> >
> > I have to load large memo field(s) data from SQL Server to Oracle 7.3
> > these memo fields have all sorts of character in them including
linefeed
> > and carriage return. When SQL Server exports the data, one can specify
a
> > ROW TERMINATOR.
> >
> > How can we specify ROW TERMINATOR in .CTL file of SQL*LOADER.
> >
> > If SQL*LOADER does not have concept of row terminator, then how does
one
> > load large text fields with linefeed and carriage returns.
> >
> > Thanks
>
> --
> -----------------------------------------------------------------------
> "Do not look to authority for truth - look to truth for authority."
> Yoshida Kenji Sensei - Yanagi Ryu Aiki Bugei
>
> Peter Giannopoulos
> generation.net
> Database & Web Applications Developer
>
> Ph: 514-845-5555 ext.218
> Fax: 514-845-5004
> ICQ# 1723017
> ------------------------------------------------------------------------
>
Received on Mon Aug 03 1998 - 17:28:57 CDT