Re: HELP: UNLOAD TO stdout
Mike Dobbert 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?
>
> One solution would be to simply copy the contents of 'szFile' to 'stdout'
> or a pipe, but that seems somewhat inefficient. Is there a 4GL statement
> similar to UNLOAD TO that might do what I want?
>
> Any help would be appreciated. Thanks in advance,
>
> Mike
>
> =============================================================================
> Mike Dobbert Hewlett-Packard MS 2LR-S
> Test Engineering Microwave Instruments Division
> mikecd@sr.hp.com 1212 Valley House Drive
> Phone (707) 794-3179 Rohnert Park, CA 95928-4999
> =============================================================================
How about a report with:
ON EVERY ROW
PRINT col1, "|", col2, "|" etc
Ian