Re: Informix and Baan .. Field separator required.

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 Well, two options: Informix uses a DBDELIMETER environment variable so that you can choose another single character as the field separator. This should allow you to change the Delimeter character to match Baans. Or you could do what I did. I wrote my own DBLOAD program which I allowed for multiple character field delimeters, and non-printable character delimeters. Ever try and parse a Pick DB record? -Mikey -- #include <std_disclaimer.h> /* Mike Segel (MS385) */ #include <No_Spam.h> #ifdef OFFENDED_BY_CONTENT The author takes no responsibility for this post. Any resembalence to a coherent rational thought is purely coincidence. -The Management. #endif ***************************** * Attention * -*- Due to AGIS's Refusal to Act Responsibly -*- Due to ACSI's latest actions, they have been pardoned. [E.Spire] We are blocking all of their domains at the packet level. This block will exist until they modify their policies to conform to existing RFCs and net community standards. We encourage all ISPs and domain holders to do the same. *****************************