SQLLDR: How to Truncate fields in input file during loading?
From: Saqib Ali <syed_saqib_ali_at_yahoo.com>
Date: 2 Oct 2002 15:21:01 -0700
Message-ID: <e431ae34.0210021421.26af6b46_at_posting.google.com>
[Quoted] Hi, My Sqlldr control file looks something like this:
)
Date: 2 Oct 2002 15:21:01 -0700
Message-ID: <e431ae34.0210021421.26af6b46_at_posting.google.com>
[Quoted] Hi, My Sqlldr control file looks something like this:
LOAD DATA
INFILE 'myDataFile.txt'
TRUNCATE INTO TABLE myTable
FIELDS TERMINATED BY '~'
trailing nullcols
(
ID sequence (count,1),
myField1 position (1) char(40), myField2 position (*) char(50), myField3 position (*) char(40)
)
However, some records in myDataFile.txt get rejected because their fields exceed that which I have specified in the above control file.
What do I need to put into my Control file to make sure that any such longer-than-allowed fields are automatically truncated then loaded?
Thanks
Saqib
Received on Thu Oct 03 2002 - 00:21:01 CEST