Redirecting Query Results

The output from a SELECT statement normally appears on the screen. You can, instead, use the Output option on the SQL menu to route query results to the printer, store them in a system file, or pipe them to a program. This option has the same purpose as the SQL statement OUTPUT.

The SELECT statement must be on the screen as the current statement. Then you can select the Output option from the SQL menu, which displays the OUTPUT menu, as Figure 15 shows.

OUTPUT:   Printer    New-file  Append-file  To-pipe  Exit
Send query results to a printer.

---------------- mystores@dbserver1 ---------- Press CTRL-W for Help -----

SELECT * FROM customer

To return to the SQL menu without redirecting query results from an OUTPUT screen, press the Interrupt key.