Re: Extract From C-ISAM v4.10.d

> cdr@xteam.co.at (Chris Drauch) writes: > Nick Bish wrote > > > >I need to dump the data from files that were used with Informix C-ISAM > >v4.10.D. All I have are the actual files themselves. (*.dat and *.idx) > > > >Are there any third party software products that can do this? > > You could try 'isamperl', a perl4 to Informix C-ISAM interface. > It's written from Mathias Koerber <Mathias.Koerber@swi.com.sg> and > works great for us. I haven't any idea where it's placed now - try > AltaVista. > > However, you must exactly know the record definition and data types of > your C-ISAM files. You should also be able to read the .dat file directly via a C-program or in some cases also with other tools. The file format is simple enough for this. It is simply fixed length records delimited by a single linefeed character. The data is dependent on the language used to write the file. Assuming this is C the fields presumably contains binary representation of the C-variables that where written. So if you read it as fixed length records and move the raw data into C-variables you should get correct values. These are then easy to write out again as ascii or do whatever else you want to do with them. If a record is deleted I think the line feed delimiter is set to 00 hex. Nils.Myklebust@ccmail.telemax.no NM Data AS, Postbox 9090, Gronland, 0133 Oslo, Norway My opinions are those of my company