Re: Extractung data from Informix database.

Paul Grayson wrote: > 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. This is a pretty simply matter. Do you have the file layouts? The .dat file is just a fixed file delimited by the 0x0a char. The only difficulty you may have will the long and double data types. The Microsoft C compiler can read these ok. There is a mark on deleted records, at this time it slips my memory. Maybe someone knows. Records do not get physically deleted, only marked.