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 » Data export


Tips on exporting data with the OUTPUT statement

Use the OUTPUT statement to export query results, tables, or views from your database.

The OUTPUT statement is useful when compatibility is an issue because it can write out the result set of a SELECT statement in several different file formats. You can use the default output format, or you can specify the file format on each OUTPUT statement. Interactive SQL can execute a SQL script file containing multiple OUTPUT statements.

The default Interactive SQL output format is specified on the Import/Export tab of the Interactive SQL Options window (accessed by clicking Tools » Options in Interactive SQL).

Use the Interactive SQL OUTPUT statement when you want to:

  • export all or part of a table or view in a format other than text

  • automate the export process using a SQL script file

 Impact on the database
 See also

Exporting data to an Excel file
Exporting data to a CSV file