Re: Informix and Baan .. Field separator required.
Posted in 1998
Topics: Performance & Tuning, Migration, Import/Export & Data Conversion
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