Copy data from one DB2 query to another DB2 table without programming

by

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

Using Withdata software DB Copier, a DB2 data transfer for Windows, MacOS, and Linux, you can copy a DB2 query results to a DB2 table easily and fast.

Download DBCopier Download DBCopier

Copy data from DB2 query results to 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.

2) Set scheduled task.

FAQ


More about DBCopierDB2 Copier