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

SQL Anywhere 12.0.0 (Français) » SQL Anywhere Server - SQL Usage » Remote data and bulk operations » Importing and exporting data » Exporting data


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"