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

In article <5289np$2kr@nic.global-one.no>, Nils.Myklebust@idg.no (Nils Myklebust) writes: <SNIP> > keith@keithd.demon.co.uk (Keith Davies) wrote: > > :Reposting article removed by rogue canceller. > > > :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. > > :Has anyone any ideas, please? > Did you rebuild the indexes with bcheck (or secheck for newer revs)? ---------------------------------------------------------------------- David Paulo, InForm Group Ltd.,PO Box 1444, Wellington, New Zealand. Ph: +64 4 472 0996 Fax: +64 4 473 2407 Email: david@inform.co.nz = What would you do if you knew that you could not fail = ----------------------------------------------------------------------