RE: data export from old unisys/informix system
> -----Mensaje original-----
> De: Obnoxio The Clown [SMTP:obnoxio@hotmail.com]
> Enviado el: mi'rcoles 28 de julio de 1999 12:02
> Para: milprog@csi.com; informix-list@iiug.org
> Asunto: 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;> .
> .
> .
>
[Jordi-Albert]
Since 6 months ago I was working with and old version on
Informix (sco -xenix)
and It have not dbexport.
so I make a list of the tables and then wit a script I unload
them
some like:
---- for w_tabname in `more table_file.txt `
---- do
---- echo " unload to ${w_tabname}.txt select * from
$tabname " > unload.sql
---- isql -s -d w_database -rcee unload
---- done
where w_database is the name of the database and -rcee are the
first letter of
the options of RDSQL - Chosse - Execute - Exit , but it depends
of the language
of your rdsql program.
for make the list ot tables you can make directly from rdsql
"select tabname from sytables where tabid > 100 "