Re: HELP: UNLOAD TO stdout

Posted in 1996

Richard Spitz — 13 Aug 1996 07:29:31 GMT — source: Informix-list mailing list archive (1991-1998)

Mike Dobbert (mikecd@sr.hp.com) wrote: : I am attempting to modify a 4GL program in which an SQL statement is : executed. This is done using the UNLOAD TO statement as follows: : UNLOAD TO szFile szSql : The SQL statement is in 'szSql' and the results are stored in the file : specified by 'szFile'. Is it possible to execute an SQL statement and : send the results to 'stdout' or a pipe, or a socket, or some other file : descriptor? There is a command in ISQL and DBACCESS callen OUTPUT. Maybe you can get that to work in a 4GL program, I've never tried. The syntax is: OUTPUT TO [<filename>|PIPE <programname>] {WITHOUT HEADINGS} <select-stmt.> Hope this helps, Richard -- +----------------------------+-------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3413 | | Klinikum Grosshadern | FAX : +49-89-7095-8886 | | 81366 Munich, Germany | | +----------------------------+-------------------------------------------+