Login | Register   
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Informix
Expertise: Beginner
Jun 26, 2000

Exporting a Table Informix 7.25

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

Answer:
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
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap