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
Aug 14, 2000

Exporting Informix

Question:
I need to migrate Informix data to an Oracle database. The current application front end imports with CSV files. Can Informix export to a CSV file?

Answer:
There is not a CSV export, per se, but you can get close by using the DELIMITER construct:

UNLOAD to flatfilename DELIMITER ',' SELECT *
FROM TABLENAME
This will give you the fields separated by commas. A CSV file usually has character fields separated by double quotes. To get this you need a statement like this:
UNLOAD to flatfilename DELIMITER ','
SELECT '"' || charfield1 || '"', noncharfield
FROM tablename.
An easier way to do this is to use a tool like WinSQL to do the complete export from one database to another. See this month's 10-minute-solution for an explanation of where to get WinSQL and how to use it.
DevX Pro
 
Comment and Contribute

 

 

 

 

 


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

 

 

Sitemap