I am trying to fload a flat file, the file contains 44 columns (44 'Û' delimiters).
Following is the sample header and data rows (header is removed from the actual file being loaded):
yes I used VARTEXT and the correct DELIMITER, also, I defined each field as VARCHAR.
Ive been stuck with this problem for 2 hrs, and I cant find any documentation of the error anywhere. Any help will be highly appreciated.
this error indicates there are less fields in your input record than DEFINEd.
Btw, 44 delimiters define 45 columns, but this should not the source of your problem.
Yes there are actually 45 columns, not 44, so I added one more column to the fastload script, but still the same error. I even removed an extra column to make the total number of columns to be 43, still the same error...
No it is not a new row, the row is actually wrapped in this forum's post.