Re: sqlldr and TAB
From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 09 Apr 2001 07:27:51 -0700
Message-ID: <3AD1C6E7.69A175BD_at_exesolutions.com>
Date: Mon, 09 Apr 2001 07:27:51 -0700
Message-ID: <3AD1C6E7.69A175BD_at_exesolutions.com>
[Quoted] 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 - 16:27:51 CEST