Exporting a Table Informix 7.25

How do I export only one table, then import the same table back into Informix?

Use the SQL UNLOAD command:

UNLOAD to filename.unl select * from tablename

When it’s finished, you can use the following SQL statement to bring it back:

LOAD from filename.unl insert into new_tablename

Share the Post:
Share on facebook
Share on twitter
Share on linkedin


Recent Articles: