Informix table data to flat file
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
Subject
Views
Written By
Posted
Informix table data to flat file
12110
January 04, 2005 03:01AM
9490
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.