Does anybody know what this errror "Column not found before end of logical record" means in SQL LOADER.
Thanx.
Printable View
Does anybody know what this errror "Column not found before end of logical record" means in SQL LOADER.
Thanx.
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.
How do I use TRAILING NULLCOLS? Where do I put it in?
Could you provide me with an example.
Thanx.
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.