DB2Copier - Copy data from one DB2 database to another »

Download DB2Copier Free Trial »     Buy DB2Copier Now »

Copy DB2 data from query to table

Click "Wizard - Query To Table" at task dialog.

Copy DB2 data from query to table - Task Window

then show the wizard.

1. Run a SQL Query.

Copy DB2 data from query to table - Run Query see ResultSet

2. Select a destination table and config fields.

Copy DB2 data from query to table - select table

3. Preview data.

Copy DB2 data from query to table - preview

4. Import.

Copy DB2 data from query to table - import

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