Copy PostgreSQL query results to DB2 table

by

Posted on by

Want to transfer data from PostgreSQL query results to DB2 table?

Try Withdata DBCopier, a PostgreSQL to DB2 converter for Windows, Mac, and Linux, Copy PostgreSQL query to DB2, Easy and Fast.

Download Withdata DBCopier Download DBCopier

Transfer data from PostgreSQL query To DB2 table

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

Choose source PostgreSQL database and logon.

convert PostgreSQL query to DB2 table - Choose PostgreSQL and logon

Choose target DB2 database and logon.

save PostgreSQL query results to DB2 table - Choose DB2 and logon

Click “Convert From Query” at task dialog.

Import data from PostgreSQL query results to DB2 table - Task Window

then show the wizard.

1. Set a PostgreSQL query.

Convert data from PostgreSQL query results to DB2 table - open query results

2. Select a destination DB2 table and config fields.

Extract PostgreSQL query results data to DB2 table - select table

3. Preview data.

Migrage data from PostgreSQL query results to DB2 table - preview

4. Transfer data from PostgreSQL query result to DB2 table.

save data from PostgreSQL query results to DB2 table - import

Transfer data from PostgreSQL query to DB2 in command line

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

Set scheduled tasks for transferring data from PostgreSQL query to DB2

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

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

FAQ

More about Withdata DBCopier – PostgreSQL to DB2 Converter

See also: