Transferring C-ISAM Formatted data

I am interested in any utilities which I can use to 'import' the data from a remote server which has it's data stored in the C-ISAM Format. The two machines are of different architectures and different versions of C-ISAM totally. I can easily report the data from the source table into an ASCII File format (either comma or '|' Pipe delimited), I would like to find a 'quick' and painless solution for rereading the ASCII Data for the import. Any ideas? I'm sure that someone has performed this process before. Thanks in advance.

"Albert E. Whale" wrote: > I am interested in any utilities which I can use to 'import' the data > from a remote server which has it's data stored in the C-ISAM Format. > > The two machines are of different architectures and different versions > of C-ISAM totally. > > I can easily report the data from the source table into an ASCII File > format (either comma or '|' Pipe delimited), I would like to find a > 'quick' and painless solution for rereading the ASCII Data for the > import. > > Any ideas? I'm sure that someone has performed this process before. DataJunction probably does it, as Wayne Martin suggested. DataStage will do it too. If your C-ISAM data does not include float and double columns, then the data is actually all stored in an architecture-independent format, so you may be able to copy the data files across. There's a program, isextract, in the IIUG archives which extracts the data from a C-ISAM data file, completely bypassing the index file. It would be possible, but not completely trivial, to rework the code to insert the data into a C-ISAM data file, and then run bcheck or secheck on the result to rebuild the index file. Or it could be written to us isopen(), isclose() and iswrite() to stuff the data into the data and index files properly. I don't have the time or inclination to do that at the moment, though. The quickest way to reload the data might be to use Informix SE and a LOAD command. You could then copy the loaded data to where you wanted it and run bcheck or secheck on the file to rebuild the index file correctly. -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"