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
Warning :Missing record delimiter "\n", saw EOF in
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 62
- Joined: Sat Mar 07, 2009 4:59 am
- Location: Chicago
- Contact:
-
- Participant
- Posts: 34
- Joined: Mon May 05, 2008 1:31 am
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.
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.
Last edited by hemanthakumar on Wed Mar 25, 2009 1:12 am, edited 1 time in total.
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>
Re: Warning :Missing record delimiter "\n", saw EO
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
tr -d '\015' < file1 > file2