error masage

[nedpan]

Does anybody know what this errror "Column not found before end of logical record" means in SQL LOADER.
Thanx.

[Krutsinger]

Sounds to me like you had your control file set to look for X number of columns, and it only found X-1 columns in the logical record.

I think it pretty much only does that when using a file enclosed by characters, and not when using positional notation.

Nevertheless, the fix is simple... use TRAILING NULLCOLS and you should be fine.

[nedpan]

How do I use TRAILING NULLCOLS? Where do I put it in?
Could you provide me with an example.
Thanx.

[Krutsinger]

load data
INFILE 'XXX.dat'
INTO TABLE XXX
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS


It's just another line to put into the header of the control file.