Informix

Hi You are right. The server I work on is a Linux server and the file I was trying to select data from was dos formatted. I ran dos2unix on the fille and this effectively fixed the issue. Thanks a lot Best regards This e-mail ...

Hi Paul Thanks a lot for your answer. I had already look for embedded delimiter in the data and found no extra delimiter in the data Fortunately I found the cause. The server I'm working on is a Linux server but the file I was trying to ...

If you transferred the file from another server, esp. a Windows computer, then there may well be additional characters in the file, including additional carriage returns at the end of each line. Remove with a "tr" command or "dos2unix" (if installed). ...