Re: Unknown version of Informix: how do I access tables?

Keith Davies wrote: > > I have a cpio backup of an Informix SE database which was created using an > unknown version of Informix. I need to access the data on two of the tables, > for which I have the definitions. > > I have restored the database files successfully to disk, but was unable to > select from the tables using the Informix version I have available, 4.10 - > system errors with core dump! > > I then tried creating a new database with two empty tables using the table > definitions, and then used system commands to copy the two .dat files > containing the data over the empty ones. Now when I do a 'select *' only one > row is retrieved from each table. Have you tried running bcheck on the original .dat files. This will work if it is the .idx file layouts which have changed. If the .dat file layouts changed then you don't have much hope. If all else fails the .dat files are ASCII. You could probably write an awk script or something to extract the records, if you know the columns. Cheers, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+