Copy data from one DB2 query to another DB2 table

by

Posted on by

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

Using DBCopier, a native GUI tool, you can copy data from one DB2 query to another DB2 table easily and fast, just a few mouse clicks!

Supports Windows XP, 7, 8, 10, 11, 2003, 2008, 2012

Here you can download and install DBCopier.

Copy data from one DB2 query to another DB2 table

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 one DB2 query to another DB2 table - Task Window

then show the wizard.

1. Run a SQL Query.

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

2. Select a destination table and config fields.

load data from one DB2 query to another DB2 table - select table

3. Preview data.

transfer data from one DB2 query to another DB2 table - preview

4. Import.

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

You can schedule and automate this converting task by:

1) Save session and create .bat file.

2) Set scheduled task.

More about DBCopier – the tool to copy DB2 data to another DB2

30-day free trial Download DBCopier