Re: Very strange SQL problem

Posted in 1998

Steven L Cooper — 22 Apr 1998 20:57:46 GMT — source: Informix-list mailing list archive (1991-1998)

KPonn <kponn@aol.com> wrote in article <1998042122360200.SAA07027@ladder03.news.aol.com>... > >We have a table with 4 char columns. The data file has the following format: > >22|John,Doe|333|Ab123456<tab>^M where <tab> is a tab (!!!) and a carriage > >return. > > > > > Thanks for the feedback. I fixed the data file by removing unnecessary tabs and > ^Ms. But I don't think we need to put a | at the end to indicate end of row > although it probably doesn't hurt to include one. Informix DOES expect the | at the end of each line...no thinking required! (If only!) Steve