Hi All,
I am creating a text file using perl. The first record I am writing as "$line" and all the other as "\n$line". At the end the file is having N number of lines. I am using this file for MLOAD (Teradata), which is reading N+1 lines in the file and failing.I am not able to find new line character or any special char at the end of the last record which may cause this issue and there is only 6 records visible.
Then I tried "sed '/^$/d' oldfile > newfile" and used New file for MLOAD. In new file it is showing 6 complete rows and 1 blank.(MLOAD is failing again). Can you please help.
Thanks.