Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
In Interactive SQL, the result set data for each command remains on the Results tab in the Results pane only until the next command is executed. To keep a record of your data, you can save the output of each statement to a separate file. If statement1 and statement2 are two SELECT statements, then you can output them to file1 and file2, respectively, as follows:
statement1; OUTPUT TO file1; statement2; OUTPUT TO file2;
For example, the following command saves the result of a query to a file named Employees.txt:
SELECT * FROM Employees; OUTPUT TO 'C:\\My Documents\\Employees.txt';
For more information, see OUTPUT statement [Interactive SQL].
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|