In Interactive SQL, the result set data (if any) for a statement remains on the Results tab in the Results pane only until the next statement 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 the results of executing them to file1 and file2, respectively, as follows:
statement1; OUTPUT TO file1; statement2; OUTPUT TO file2;
For example, the following statements save the result of a query to a file named Employees.txt:
SELECT * FROM Employees; OUTPUT TO 'C:\\My Documents\\Employees.txt';
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|