SQL loader: TRAILING NULLs where not necessary
From: Jan Doggen <massoft_at_tref.nl>
Date: Tue, 18 Sep 2001 22:50:15 +0200
Message-ID: <9o8bnd$fmod$1_at_reader03.wxs.nl>
Date: Tue, 18 Sep 2001 22:50:15 +0200
Message-ID: <9o8bnd$fmod$1_at_reader03.wxs.nl>
We load an ASCII file with exactly the right number of fields into a table like this:
The last few fields are empty (null), so each record ends in the required number of Tab separators.
However, SQL loader refuses to load this!
If we ad TRAILING NULLCOLS, the data loads just fine, in the right fields.
How come?
If we supply enough data fields, although NULL values, this shoudl work
without TRAILING NULLs, shouldnt it?
Received on Tue Sep 18 2001 - 22:50:15 CEST