Also be careful if you are copying/pasting the script from an editor window on Windows into a dbisql session, etc. I have had issues with hidden/embedded carriage returns (^M).
Even editing the script in dbisql after will still give errors as there is a ^M still there.
I sometimes will run the script through dos2unix anyway and resolve the issue that way.
(I've also seen this issue in a .cfg file copied from Windows where the ^M hidden after the server name caused startup problems until I ran the .cfg through dos2unix).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.