Re: sqlldr and TAB
From: Matt B. <mcb_at_ds.znet.com>
Date: Mon, 9 Apr 2001 19:15:57 -0700
Message-ID: <td4r6o7m3hdl65_at_corp.supernews.com>
Date: Mon, 9 Apr 2001 19:15:57 -0700
Message-ID: <td4r6o7m3hdl65_at_corp.supernews.com>
"Carsten Landeck" <Landeck.c_at_zdf.de> wrote in message
news:3ad1b008$0$4943$73bec562_at_personalnews.de.uu.net...
> 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
Try chr(9) instead of '\t'.
-Matt Received on Tue Apr 10 2001 - 04:15:57 CEST