Import data from Oracle to DB2

Click "Import From Query" at task dialog.

Import data from Oracle Query To DB2 Table - task window

then show the Import Query form.

1. Enter Source Query.

Import data from Oracle Query To DB2 Table - enter query

2. Select Target Table

Import data from Oracle Query To DB2 Table - enter file name

3. Summary.

Import data from Oracle Query To DB2 Table - summary

4. Import.

Import data from Oracle Query To DB2 Table - export

For repeatable task, you can click "Save Session" button to save config, then run it next time. see also: Save and load session.