'^M' character at end of lines

Question

When I run a particular SQL script in Unix environments, I'm am seeing a '^M' character at the end of each line of the SQL script as it is echoed to the command-line. I don't know on which OS the SQL script was originally created.

What is causing this and how do I fix it?

Answer 1

Try fixing the line endings in vi by executing the following code:

:set fileformat=unix

:w