Exporting data

Use the following procedure to export data in .csv format to the location that you chose. The output includes the column headings.

To export data

New console

Select or create a Db2 object view that contains the object or objects that you want to export.
For more information, see Creating a Db2 object view.
Navigate to and select your source object or objects.
For more information, see Navigating to an object.
Perform one of the following actions:
- To export all objects in the view, right-click anywhere in the results pane and select Select All; then right-click again and select Export data.
- To export specific objects, select one or more object entries, right-click, and select Export Data.
When prompted, select a location for the exported data.
The default file name is export_data.csv.
Save the file.

Classic console

Select or create a Db2 object view that contains the object or objects that you want to export.
For more information, see Creating a Db2 object view.
Navigate to and select your source object or objects.
For more information, see Navigating to an object.
Perform one of the following actions:
- To export all objects in the view, right-click anywhere in the results pane and select Select All ; then right-click again and select Export data .
- To export specific objects, select one or more object entries, right-click, and select Export Data .
When prompted, select a location for the exported data.
The default file name is export_data.csv.
Save the file.