Warning :Missing record delimiter "\n", saw EOF in

[sureshreddy2009]

Hi
Enter the correct format in sequential file
as u said that all records are loaded but in logs it is saying that one record is rejected, this is because, at the end of file they entered one empty line , so all records are loaded into the target and one line is not loaded because of not finding any delimiter, this is purely the "final delimiter format mismatch" in sequential file
and for avoiding charater at the end of each line, set the record delimiter format

[hemanthakumar]

Hi,
Use the follwing command in Unix to remove control (^M) characters in Source file.

sed 's/'`echo "\015"`'//g' filename.

To remove the warning "Missing record delimiter "\n", saw EOF instead"
go to end of the last line of the source file give one Enter .It will remove the warning.

[prasad111]

Try using dos2unix command after sftp'ing the file from script

Code: Select all

In Linux
$dos2unix <file_name> 
In some unix systems[I guess in AIX]
$dos2unix <file_name> file_name.tmp
mv file_name.tmp <file_name>

[pxlearn]

Try the below unix command to remove the ^M chars from the file in Datastage before job routine and pass the input file as file2

tr -d '\015' < file1 > file2