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 || '"', noncharfieldFROM 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.

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

Overview

Recent Articles: