Copy one DB2 query results to another DB2 table

by

Want to copy data from DB2 query to another DB2 table?

Using Withdata DB Copier, a desktop DB2 data transfer for Windows, MacOS, and Linux, Copy DB2 query results to DB2 table, Easy and Fast.

Download Withdata DBCopier Download DBCopier

Copy data from DB2 query results to another DB2 table

Login to source and target DB2 -> Enter DB2 auery -> Set target DB2 table -> Copy DB2 data

Choose source/target DB2 database and logon.

copy data between DB2  - Choose DB2 and logon

Click “Convert From Query” at task dialog.

Copy data from DB2 query to DB2 table - Task Window

then show the wizard.

1. Enter a DB2 SQL Query.

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

2. Select a destination table and config fields.

load data from DB2 query to DB2 table - select table

3. Preview data.

transfer data from DB2 query to DB2 table - preview

4. Copy DB2 query results data to DB2 table.

convert data from DB2 query to DB2 table - import query results

Copy a DB2 query results to a DB2 table in command line

Save “Copy DB2 query to table” session, then you can:

Set scheduled tasks for coping a DB2 query results to a DB2 table

You can schedule and automate this “DB2 Copy” conversion task by:

  1. Save session and create .bat (Windows) or .sh (Linux/macOS) file for “DB2 Copy” conversion.
  2. Set scheduled task for “DB2 Copy” conversion.

FAQ


More about Withdata DBCopierDB2 Copier