Re: Unload tables (very beginner)
Posted in 1997
Alessio Vremec wrote:
> Hi all.
> I need to unload (export) some tables from an Informix db to an ascii
> file (I want to reload them to another db).
> Is it possible?
> I have no manuals, and have no experience with Informix.
> Any kind person could help me?
> Thanks in advance.
> Alessio
Alessio.
Of course, you can do it.
The first thing you can do is using 'unload' sql statement as follows.
unload to filename select * from tablename;You can also use ESQL/C program and dbexport utility.
But I think 'unload' sql statement is quite easy to use.
Good luck!
--
**********************************************************************
SI Business Team/S/W Dept./Sales Div.
Daou Technology Inc.
6F,DaeAh Bldg.,707-7,Yuksam-Dong,Kangnam-Gu,Seoul,Korea
Tel: 82-2-3450-4673(Dir.) 82-2-3450-4500(Rep.) Fax: 82-2-555-0141
mailto:duckskim@daou.co.kr