Data Conversion

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