Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i am facing a problem here when tryig to load a text file it is only taking only 20K records but actually there are 60k records
and i tried this option ignore eof but i do not know why we use for it
can any one help me on this
Hi,
This may be because there will be a blank line after that record from where the data is not coming.
Kindly check the txt file.
Regards,
Kaushik Solanki
i checked it throughly but the same issue
i can not see any blank lines
Hi,
If possible post the txt file.
Regards,
Kaushik Solanki
We had this probablem because the file contained some odd characters (SUB for one). When we added the ignore EOF option, the entire file would load.
Responding since I was looking for the same info and found the answer to the basic question on eof.
Its specifically for text files as I understand. See link below for detail.