Page 1 of 1

Missing Record Delimiter as " " Issue

Posted: Fri Oct 09, 2009 12:47 pm
by 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,

Posted: Fri Oct 09, 2009 9:18 pm
by 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.