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';

Writing database output to a file

Task

See also