how to user sqlldr in this case.

From: Yang Lee <yang__lee_at_ausi.com>
Date: Wed, 1 Sep 2004 11:13:51 +0000 (UTC)
Message-ID: <d2e9d8b6e9dc6eaadd37919ecc3475f1.93862@mygate.mailgate.org>

Hi all,
I have a huge data in a text file.

10 12223 closed 647 90

10                     90
10                  67  90
10  12a     closed 

10 123r closed 67 90

each field is separated by a tab and each field is of different length. and many fields as you see are NULL.
Now I want to use sqlldr.exe
to load the data in my table I use following control file WITH my text data file renamed as etc.dat.

LOAD DATA
INFILE 'etc.dat'
BADFILE 'sample.bad'
DISCARDFILE 'sample.dsc'
APPEND
INTO TABLE mytable
TRAILING NULLCOLS
(
fname INTEGER TERMINATED BY " " NULLIF mname=BLANKS , mname CHAR TERMINATED BY " " NULLIF mname=BLANKS , lname CHAR TERMINATED BY WHITESPACE,
gname CHAR TERMINATED BY WHITESPACE,
hname INTEGER TERMINATED BY WHITESPACE,
)

it doesn't solve the purpose. please provide me correct control file. Thanks a lot in advance,
Lee

-- 
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

Received on Wed Sep 01 2004 - 06:13:51 CDT