Re: sqlldr and TAB

Hi,

For loading the TAB delimited file use:

LOAD DATA
 INFILE 'import.tab'
 INTO TABLE imp
 INSERT
[Quoted]  FIELDS TERMINATED BY X'09' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS  (ObjClass,
 ...
 )

Best regards, Dmitry

--
http://www.ispirer.com/chyfo.html - Tool exports data to CSV flat file,
generates CREATE TABLE, CREATE INDEX scripts for Oracle and control files
for SQL Loader.


"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

>

>