You can unload data from a database to a reload file, a new database, or an existing database using the Unload Database Wizard in Sybase Central.
When unloading into a variable, no privileges are required. Otherwise, the required privileges depend on the database server -gl option, as follows:
If the -gl option is set to ALL, you must be the owner of the tables, or have SELECT privilege on the tables, or have the SELECT ANY TABLE system privilege.
If the -gl option is set to DBA, you must have the SELECT ANY TABLE system privilege.
If the -gl option is set to NONE, UNLOAD is not permitted.
When unloading to a file on a client computer:
You must have the WRITE CLIENT FILE privilege.
You must have write permissions on the directory where the file is located.
The allow_write_client_file database option must be enabled.
The write_client_file secure feature must be enabled.
Click Tools » SQL Anywhere 16 » Unload Database.
Follow the instructions in the Unload Database Wizard.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|