Exporting data with the Export Wizard

Use the Export Wizard in Interactive SQL to export query results in a specific format to a file or database.

Prerequisites

You must be the owner of the table you are querying, have SELECT privilege on the table, or have the SELECT ANY TABLE system privilege.

Task

Execute a query.
In Interactive SQL, click Data » Export.
Follow the instructions in the Export Wizard.

Results

The query results are exported to the specified file or database.

Example

Execute the following query while connected to the sample database. You must have SELECT privilege on the table Employees or the SELECT ANY TABLE system privilege.

SELECT * FROM Employees WHERE State = 'GA';

The result set includes a list of all the employees who live in Georgia.
Click Data » Export.
Click In a database and then click Next.
In the Database type list, click UltraLite.
In the User Id field, type DBA.
In the Password field, type sql.
In the Database file field, type C:\Users\Public\Documents\SQL Anywhere 16\Samples\UltraLite\CustDB\custdb.udb.
Click Next.
Click Create a new table.
In the Table name field, type GAEmployees.
Click Export.
Click Close.

Click SQL » Previous SQL.

The OUTPUT USING statement created and used by the Export Wizard appears in the SQL Statements pane:

--  Generated by the Export Wizard
output using 'driver=UltraLite 16;UID=DBA;PWD=***;
DBF=C:\\Users\\Public\\Documents\\SQL Anywhere 16\\Samples\\Ultralite\\custdb\\custdb.udb' 
    into "GAEmployees" 
    create table on

Discuss this page in DocCommentXchange.