Export data with the Export Wizard

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

 To export result sets data using Interactive SQL

  1. Execute a query.

  2. In Interactive SQL, choose Data » Export.

  3. Follow the instructions in the Export Wizard wizard.

 To export result sets data to an UltraLite database using Interactive SQL

  1. Execute the following query while connected to the SQL Anywhere sample database.

    SELECT * FROM Employees
WHERE State = 'GA';

    The result set includes a list of all employees who live in Georgia.

  2. Choose Data » Export.

  3. Click In A Database.

  4. In the Database Type list, select UltraLite.

  5. In the User Id field, type dba.

  6. In the Password field, type sql.

  7. In the Database File field, type C:\Documents and Settings\All Users\Documents\SQL Anywhere 12\Samples\UltraLite\CustDB\custdb.udb.

  8. Click Next.

  9. Click In A New Table.

  10. In the Owner field, type dba.

  11. In the Table Name field, type NewTable.

  12. Click Export.

  13. Click Close.

  14. Choose 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 12;UID=dba;PWD=sql;
DBF=C:\Documents and Settings\All Users\Documents\SQL Anywhere 12\Samples\UltraLite\CustDB\custdb.udb' 
INTO "dba"."NewTable" 
CREATE TABLE ON
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0