Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - SQL Usage » Remote Data and Bulk Operations » Importing and exporting data » Using SQL command files

 

Writing database output to a file

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].