MySQL Forums
Forum List  »  Informix

Informix table data to flat file
Posted by: gills rajan
Date: January 04, 2005 03:01AM

Dear all,

I would like to export informix table data to flat files and take to Oracle. I really dont know which utility to use in Informix, I tried to save the output of the select * from table. But again, the null values are a problem. If there is any function to replace null with some characters it would have solved (like NVL function in pl/sql).

I heard we can write a small 4GL script to run in the server to return all table data with delimiters.

I really appreciate if you can be any helpful to me..

many thanks and regards

Options: ReplyQuote

Written By
Informix table data to flat file
January 04, 2005 03:01AM
January 11, 2005 12:28PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.