Question:
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)?
Answer:
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.