Re: HELP: UNLOAD TO stdout

: 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? You can output the results to a named pipe. You create the pipe and then specify it's path in the UNLOAD (or LOAD) command. I've used this technique to unload data from a table into the pipe and then load the data into another table from the pipe with the unload/load running simultaneously. -- Stefanie Vario svario@zenacomp.com ZenaComp Incorporated http://www.zenacomp.com/~zenacomp