Re: ISQL Text File Output
Posted in 1997
Chris Drauch — — source: Informix-list mailing list archive (1991-1998)
Jason Kruse wrote
>
>Being new to Informix, I need a few simplem questions answered in a
>hurry. How can I pipe the output of a "Select * from table_name" to a
>text file on a SCO box running Informix? I am used to WATCOM sql
>where I run the query and execute a output command to store the result
>as a comma delimited file. Any help would be greatly appreciated.
>thanks.
Well, you are new to Informix - but that shouldn't hold you away from
pressing <CTRL>-W at ISQL Query editor and watch for the nice help you
could get :-)
UNLOAD TO "pathname" [DELIMITER "char"] SELECT-statement
--
Chris Drauch <cdr@xteam.co.at> ... just speaking for myself ...