Use the Export Wizard to export query results in a specific format to a file or database.
Execute a query.
In Interactive SQL, choose Data » Export.
Follow the instructions in the Export Wizard wizard.
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.
Click the Database tab.
In the Database File field, type C:\Documents and Settings\All Users\Documents\SQL Anywhere 11\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.
Choose SQL » Previous SQL.
The IMPORT statement created and used by the Import Wizard appears in the SQL Statements pane:
-- Generated by the Export Wizard OUTPUT USING 'driver=UltraLite 11;UID=dba;PWD=sql; DBF=C:\Documents and Settings\All Users\Documents\SQL Anywhere 11\Samples\UltraLite\CustDB\custdb.udb' INTO "dba"."NewTable" CREATE TABLE ON |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |