Use the UNLOAD statement from SQL Editor panel to write the rows retrieved in a SELECT statement to an operating-system file.
Syntax
UNLOAD TO 'filename' DELIMITER 'delimiter' <SQL SELECT statement>
Usage
To use the UNLOAD statement, you must have the Select privilege on all columns selected in the SELECT statement. The SELECT statement can consist of a literal SELECT statement or the name of a character variable that contains a SELECT statement.
UNLOAD TO File
The UNLOAD TO file contains the selected rows retrieved from the table. You can use the UNLOAD TO file as the LOAD FROM file in a LOAD statement.
For additional information on UNLOAD TO statement, see Informix SQL Syntax Guide.