Re: Extractung data from Informix database.
Posted in 1999
Topics: Platform-Specific Issues
Paul Grayson wrote: > > I have come across a company running an accounting system under SCO > Unix, using Informix as the underlying database. > > Unfortunatly the company that produced the database has ceased trading, > and no-one has any ideas if this database is Year 2000 compliant. > > The system appears to be a Xenix binary - running 'strings' on the > binary shows Informix copyright messages dating no recently than 1988, > although some of the include files used (also obtained from strings) > appear to date from 1991. > > I have managed to extract the .dat and .idx files (despite no TCP stack > on the Unix system), and want to know if there are any tools available > to extract the data. I am only interested in the customer lists and not > the numerical data. > I have now determined that these files are in the standard C-ISAM format. Since this is a one-time conversion operation, are there any freely available (or reasonably inexpensive) tools to allow an export of data to be performed. I am not bothered on the platform, but would prefer either Linux or NT. Using a recent Linux demo of Informix I have been able to determine that the integrity of the files appears to be fine.