Login | Register   
LinkedIn
Google+
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
May 30, 2000

Data Conversion

Question:
What is the most efficient method of converting Informix data in a Unix operating system to text or dbf data in an NT operating system (size = 8GB)?

Answer:
Use dbexport to export all of the data in the database. It will output a series of text files delimited by the UNIX pipe ( | ) symbol.

To deal with just one table, a few tables or parts of a table, use the following SQL:

UNLOAD to "filename" SELECT 
Submit a Tip Browse "Web Development" Tips Browse All Tips
Comment and Contribute

 

 

 

 

 


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

 

 

Sitemap