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

This is a multi-part message in MIME format. --------------13107F54458A Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit keith@keithd.demon.co.uk (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. Been a loooong time since I've tried to do anything like this. Let's see how good my memory is! First, create a table with the tab defs as you mention above. Copy the dat files over those created. Then run bcheck on the tables/files. You may have to zero out the .idx files for this to work right. As long as the table structure in the .dat file matches *exactly* what you have used for the table, bcheck should correctly rebuild the .idx file so that all the rows in the .dat file are accessible. -- Dave Kosenko, Informix Professional Services *********************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney --------------13107F54458A Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="Disclaim" ************************************************************************* Disclaimer: All opinions expressed in this message are well-reasoned and insightful; needless to say, they are not those of Informix Software, its partners or lackeys. Anyone who says otherwise is itching for a fight. --------------13107F54458A--