Re: sqlldr and TAB

Include the following

FIELDS TERMINATED BY X'09' This is the hex code for a TAB.

"Daniel A. Morgan" wrote:

> Is it fixed length?
>
> Daniel A. Morgan
>
> Carsten Landeck wrote:
>
> > Hi
> > I have a beginner question:
> > In the *.ctl file I have the option "FIELDS TERMINATED BY"
> > I'm using tabulators, but '\t' doesn't work.
> >
> > My data-source file is ok
> >
> > -> Value TAB value TAB value CR <-
> >
> > LOAD DATA
> > INFILE 'import.tab'
> > INTO TABLE imp
> > INSERT
> > FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
> > (ObjClass,
> > ...
> > )
> >
> > The result is, that the whole tupel is stored in the first field.
> >
> > Has someone a hint?
> >
> > Carsten
  Received on Mon Apr 09 2001 - 17:39:47 CEST