The Unload utility allows you to unload only table data.
You must be the owner of the table being queried, or have SELECT privilege on the table, or have the SELECT ANY TABLE system privilege.
Context and remarks
The statements required to recreate the schema and reload the specified tables are written to reload.sql in the current local directory.
You can unload more than one table by separating the table names with a comma.
Run the dbunload command, specifying connection parameters using the -c option, table(s) you want to export data for using the -t option, whether you want to suppress column statistics by specifying the -ss option, and whether you want to unload only data by specifying the -d option.
For example, to export the data from the Employees table, run the following command:
dbunload -c "DBN=demo;UID=DBA;PWD=sql" -ss -d -t Employees C:\ServerTemp\DataFiles
The reload.sql file will be written to the client's current directory and will contain the LOAD TABLE statement required to reload the data for the Employees table. The data files are written to the server directory C:\ServerTemp\DataFiles.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|