Re: C-ISAM to Informix rdb con

In-Reply-To: <1hqc37INNaj@emory.mathcs.emory.edu> markf@sequoia.sequoia.com (Mark R. Friedman) TITLE: C-ISAM to Informix rdb conversion utilities In <1hqc37INNaj@emory.mathcs.emory.edu> Mark R. Friedman asks: > What utilities/tools exist to ease moving data from (Informix) C-ISAM files > over to a series of Informix databases? We've recently acquired a suite of > 'replacement' applications and would like to move the existing data over to > the new apps, but our software vendor claims the only way to do so is by > writing a suite of C programs (for which he'll charge us a mere arm and leg). > Is there a better way? We have access to what I believe to be the full range > of Informix products, and I _want_ to assume that there's a cleaner and > easier approach. Many thanks for any ideas or pointers... If they are REALLY C-ISAM files then, unless I've missed my guess, all you need to know is the type of each data field in each data file. You also need to know the keys for each index. Now, in informix, create data tables of exactly the same type. Now once you've created the tables you login as user informix (or any other user with DBA privilage). Now create a default form for the table SYSTABLES. Now for each table you've created in SQL, change the dirpath field to point to your original data tables. So, you now have you're old data in you shiny new database. At this point I would suggest that you UNLOAD the bits of the data you need and LOAD it into you new apps. I hope this helps. | I'm not bad, I'm just drawn that way -- Jessica Rabbit | |------------------------------------------------------------| | Stuart Hemming | shemminga@cix.compulink.co.uk | | Tudor Labels Ltd | uunet!cix.compulink.co.uk!shemminga | | Roman Bank Bourne | Tel : (+44) 778 426444 | | Lincs PE10 9LQ. UK. | Fax : (+44) 778 421862 | Stuart |8-)