Re: Informix C_ISAM

gsturkenboom@lic.co.nz wrote: > Informix C-ISAM V4 > SCO V5.61 > > Anyone have any experience extracting data from Informix C-ISAM files? See isextract in the IIUG Software Archive. > I can see a bunch of .idx and .dat files. I need to extract the data from > these files but there is no supporting DBMS so I cannot run any utility > such as isql or dbaccess to do the unload. > > I would like to produce csv or pipe delimited files. Anyone got any ideas? > I don't even know the structure of these files. If you've got an xyz.dbd file, you've got a pre-SQL Informix 3.30 database. I have software that can be compiled to deduce the actual structure of the data. Otherwise, if you have a systables.dat or (more importantly) syscolumns.dat, then you have an SE database and we can deduce the actual structure of the data. If you have neither, you have a pure C-ISAM application. You'll have to make some educated guesses at what's in the files. There's some information that can be determined from the .idx files, but not everything. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/