Re: Informix and Baan .. Field separator required.

Informix allows any ASCII character for field separators. The only thing you must make sure is that character is not part of your data. On a couple of occasions when I could not come up with a field separator because of this issue, I've used the fixed length record format. It needs a little bit more work, but solves the problem. Good luck, Arun Srinivas Vadrevu wrote: > Hello, > We are attempting data migration in Baan. Our prcess involves > dumping the data into Flat Files (ASCII Files) with a Field Separator > and then loading this data into the table spaces using High Performance > Loaders (HPL). > > How ever we have a problem. We are uanable to fix the Filed > Separator. We tried with ^A, but this does not work. Any other character > like pipe ( | ) also does not work since this is a very commonly used > character in German. > > So the Question is: What character can be used as a filed separator > in Informix. > > HELP HELP HELP. > > regards, > Srini