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

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

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

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.
Choose Data » Export.
Click In A Database.
In the Database Type list, select UltraLite.
In the User Id field, type dba.
In the Password field, type sql.
In the Database File field, type C:\Documents and Settings\All Users\Documents\SQL Anywhere 12\Samples\UltraLite\CustDB\custdb.udb.
Click Next.
Click In A New Table.
In the Owner field, type dba.
In the Table Name field, type NewTable.
Click Export.
Click Close.

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

Discuter à propos de cette page dans DocCommentXchange.