Data Conversion

Data Conversion

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)?

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 

This also will unload in pipe-delimited format.


Share the Post: