Re: data export from old unisys/informix system

From: Marcel Gsteiger <milprog@csi.com> > >One of my customers has a 10-year-old unisys unix system with a informix >application, but no documentation whatsoever. They would like to just >export the database in some form to be re-imported on a new, different >system. Their database is not large, the biggest table occupies about >100'000 records. > >For data exchange, there are two possibilities: >1) 5 1/4 inch floppy disks >2) serial terminal connections > >My idea was to connect a PC to the serial line and "download" the data >in some form. Is there a source for informix/PC export utilities that >could help to perform this task? If you're lucky, you'll have a program called dbexport which will unload the data and the schema in one shot. Use dbexport -- for the necessary options. If you have enough disk, you should be able to just say dbexport dbname If you haven't got dbexport, you'll have to do something like: dbschema dbname schemaname.sql Then: isql dbname Q N unload to tablename1.unl select * from tablename1; unload to tablename2.unl select * from tablename2; unload to tablename3.unl select * from tablename3;. . . Hope this helps. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com