Online Documentation for SQL Manager for DB2

Export/import data


You can export data from a database table into an external file of any supported format by means of the Export Data Wizard.

There are several ways to launch Export Data Wizard:

  1. Open the Data or Results tab, press iconTools_ExportData Export Data on one of the Data View toolbars.
  2. Open the Data or Results tab, choose Data Manipulation | iconTools_ExportData Export Data in the Data Grid context menu.
  3. Open the table context menu in the DB Explorer, choose the Data Manipulation | iconTools_ExportData Export Data item.
  4. Open the Data or Results tab and use the shortcut Shift+Ctrl+E.

 

You can import data from external sources into a table or view using Import Data Wizard:

  1. Open the Data tab, press the iconTools_ImportData Import Data button on one of the Data View toolbar.
  2. Open the Data tab, choose Data Manipulation | iconTools_ImportData Import Data in the Data Grid context menu.
  3. Open the table context menu in the DB Explorer, choose the iconTools_ImportData Import Data item.
  4. Open the Data tab and use the shortcut Ctrl+I.

 

Note: Export and import data tools are available in full version of SQL Manager for DB2 only.