Re: Informix and Baan .. Field separator required.

Posted in 1998

Art S. Kagel — Thu, 16 Jul 1998 17:34:05 -0400 — source: Informix-list mailing list archive (1991-1998)

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. Any printable character can be used as a field separator. Try the tilde (~). Art S. Kagel