How to import/export table from informix database

[sva srinivas.vanapalliqon2trade.de]

Hello,

Can somebody tell me how to import / export tables from informix database

regards,
Srinivas

[Lori]

Which DB engine? SE or IDS?

Using SE:
Run this SQL stmt to create delimited text file for each table:
Unload to filename select * from tablename;

Run this SQL stmt to load the data:
Load from filename insert into tablename;

We're not using IDS, but I think it is similar, perhaps different commands.

Lori

"sva" srinivas.vanapalliqon2trade.de wrote:
>
>Hello,
>
>Can somebody tell me how to import / export tables from informix database
>
>regards,
>Srinivas

[Gary]

"Lori" <lori.helton@citynmb.com> wrote:
>
>Which DB engine? SE or IDS?
>
>Using SE:
>Run this SQL stmt to create delimited text file for each table:
>Unload to filename select * from tablename;
>
>Run this SQL stmt to load the data:
>Load from filename insert into tablename;
>
>We're not using IDS, but I think it is similar, perhaps different commands.
>
>Lori
>
>"sva" srinivas.vanapalliqon2trade.de wrote:
>>
>>Hello,
>>
>>Can somebody tell me how to import / export tables from informix database
>>
>>regards,
>>Srinivas
>

[Gary]

"Gary" <Gary.J.Lively.-ND@disney.com> wrote:
Works for both.

IDS has a High Performance Loader (HPL) which is much faster for very large
tables.

- Gary
>
>"Lori" <lori.helton@citynmb.com> wrote:
>>
>>Which DB engine? SE or IDS?
>>
>>Using SE:
>>Run this SQL stmt to create delimited text file for each table:
>>Unload to filename select * from tablename;
>>
>>Run this SQL stmt to load the data:
>>Load from filename insert into tablename;
>>
>>We're not using IDS, but I think it is similar, perhaps different commands.
>>
>>Lori
>>
>>"sva" srinivas.vanapalliqon2trade.de wrote:
>>>
>>>Hello,
>>>
>>>Can somebody tell me how to import / export tables from informix database
>>>
>>>regards,
>>>Srinivas
>>
>

[joey]

"Lori" <lori.helton@citynmb.com> wrote:
>
>Which DB engine? SE or IDS?
>
>Using SE:
>Run this SQL stmt to create delimited text file for each table:
>Unload to filename select * from tablename;
>
>Run this SQL stmt to load the data:
>Load from filename insert into tablename;
>
>We're not using IDS, but I think it is similar, perhaps different commands.
>
>Lori
>

Thanks a lot, Lori
I was confusing in this, too.
Your answer had helped me.