OUTPUT
Go Up to isql Command Reference
Redirects output to the named file or to standard output.
OUTPUT [filename];
Argument | Description |
---|---|
<filename> |
Name of the file in which to save output; if no file name is given, results appear on the standard output |
Description: OUTPUT
determines where the results of isql
commands are displayed. By default, results are displayed on standard output (usually a screen). To store results in a file, supply a <filename> argument. To return to the default mode, again displaying results on the standard output, use OUTPUT
without specifying a file name.
By default, only data is redirected. Interactive commands are not redirected unless SET ECHO
is in effect. If SET ECHO
is in effect, isql
displays each command before it is executed. In this way, isql
captures both the results and the command that produced them. SET ECHO
is useful for displaying the text of a query immediately before the results.
Error messages cannot be redirected to an output file.
Using OUTPUT
<filename> from within an isql
session has the same effect as using the option -output
filename
from the command line.
You can optionally delimit the filename with double or single quotes. This allows you to use filenames with spaces in OUTPUT
statements.
Example: The following example stores the results of one SELECT
statement in the file, sales.out
. Normal output processing resumes after the SELECT
statement.
OUTPUT sales.out;
SELECT * FROM SALES;
OUTPUT;