sqlldr and TAB
From: Carsten Landeck <Landeck.c_at_zdf.de>
Date: Mon, 9 Apr 2001 14:50:02 +0200
Message-ID: <3ad1b008$0$4943$73bec562_at_personalnews.de.uu.net>
Date: Mon, 9 Apr 2001 14:50:02 +0200
Message-ID: <3ad1b008$0$4943$73bec562_at_personalnews.de.uu.net>
Hi
I have a beginner question:
[Quoted] [Quoted] In the *.ctl file I have the option "FIELDS TERMINATED BY"
[Quoted] [Quoted] I'm using tabulators, but '\t' doesn't work.
[Quoted] 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 - 14:50:02 CEST