Re: Informix and Baan .. Field separator required.

I didn't undestood exactly what your real purpose is, but if you are trying to import data into Baan tables you should be aware of the existence of smal thigns like hash collums and reference counters. The best way to import data into Baan is using Baan tools: Exchange tool or Creating Tables from Sequential Dump. Both methods use ASCII files, are database independent, and allow the use of diferent separators. Good luck! Jo'o Carvalho Srinivas Vadrevu wrote in message <35AE2238.D900BBFC@baan.com>... >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 >