Re: Converting data to Informix from PICK!

P F SIEGEL wrote: > > My company is moving from a Pick database to Informix. I need to transfer > / convert only our data, not the application software (we have bought > new). This is typical maufactuing data, orders, invoices, accounts, > customers, inventory and the like. Has anyone done this? Can it be done > via tape rather than having to re-key all into the Informix DB? .Some of > my concerns are dealing with Pick's variable field lengths and > mulit-values. All suggestions and experiences greatly appreciated. > Thanks, > Peter Siegel Peter, The answer is yes. (Sort of) To make a long story short, you can do it, but you will have to know the layouts of your pick data. Depending on the version of PICK, you can write some routines to parse the data files and insert in to a database. I just need a PICK database backup tape to be sure. There are other issues on the multivalue columns, like do you want to create a serial field as the key, or build a composite key based on the rest of the records. There are actually several ways to get the data out of pick, but the best way is to take it from an archieve tape. Send me some email on this. -Mike Segel P.S. Geez, can't you guys spell your last name right? ;-)