Online Documentation for Data Pump for DB2

Step 7 - Selecting tables for data import

At this step of the wizard you can specify tables to import data from.

To select a table, you need to move it from the Available tables list to the Selected tables list. Use the Items - Move to Selected Items - Move to Available Items - Move all to Selected Items - Move all to Available buttons or drag-and-drop operations to move the tables from one list to another.


Hint: To select multiple tables, hold down the Shift or Ctrl key while selecting the table names.


Step 7 - Selecting tables for data import


You can also set SQL criteria for fetching data from the corresponding source table with a WHERE clause used within the Criterion Editor dialog.


To open Criterion Editor, use the ellipsis btnEllipsis button next to the Criterion value.


Note that the Available tables list only contains tables for which structure has been already created (e.g. at the previous step), i.e. you can only choose to import data to those tables which already exist in the target DB2 database.


When you are done, click the Next button to proceed to importing data.