Exporting table data

The Unload utility allows you to unload only table data.

Prerequisites

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.

Task

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.

Results

The table data is exported to the specified directory.

Exporting table data

Task

See also