Missing Record Delimiter as " " Issue

[Aquilis]

Hello All,
We are facing following error, when we execute/run through Script.

Code: Select all

Missing record delimiter "
", saw EOF instead

In script we are actaully FTPing the data file & removing '^M' characters as well.
But when Execute the same Datastage Job only for same Data file(after removal of the '^M') we are not encountering any issues. As single datatstage job execution we are ok.

We are expecting "\n" as end but it's showing someother special character (as a Box) in the error log.

We serached throught the Dsxchange & found few posts related to this & tried every possible solutions nothing fruitful found at our end. Can anybody point out where we might be going wrong !!!

Thanks,

[ray.wurlod]

Does the last line in the file have its record terminator character? This error often occurs when it doesn't, but is expected to be there.