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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Data import and export » SQL script files

 

Writing database output to a file

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.

Prerequisites

The privileges required depend on the statements being executed.

 Task
  • 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;

Results

The output of each SQL statement is saved to a separate file.

Example

The following statements save the result of a query to a file named Employees.csv in the C:\LocalTemp directory:

SELECT * FROM Employees;
OUTPUT TO 'C:\\LocalTemp\\Employees.csv';

 See also