Transfer data from DBF query to DB2 table without programming

by

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

Using Withdata software DB Copier, a DBF to DB2 converter for Windows, MacOS, and Linux, you can transfer data from DBF (dBase, xBase, FoxBase, Visual FoxPro, Clipper) query result to DB2 table easily and fast.

Download DBCopier Download DBCopier

Transfer data from DBF (dBase, xBase, FoxBase, Visual FoxPro, Clipper) query To DB2 table

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

Choose source DBF database and logon.

convert DBF  (dBase, xBase, FoxBase, Visual FoxPro, Clipper) query to DB2 table - Choose DBF and logon

Choose target DB2 database and logon.

save DBF  (dBase, xBase, FoxBase, Visual FoxPro, Clipper) query results to DB2 table - Choose DB2 and logon

Click “Convert From Query” at task dialog.

Import data from DBF  (dBase, xBase, FoxBase, Visual FoxPro, Clipper) query results to DB2  table - Task Window

then show the wizard.

1. Set a DBF query.

Convert data from DBF  (dBase, xBase, FoxBase, Visual FoxPro, Clipper) query results to DB2  table - open query results

2. Select a destination DB2 table and config fields.

Extract DBF  (dBase, xBase, FoxBase, Visual FoxPro, Clipper) query results data to DB2  table - select table

3. Preview data.

Migrage data from DBF  (dBase, xBase, FoxBase, Visual FoxPro, Clipper) query results to DB2  table - preview

4. Transfer data from DBF (dBase, xBase, FoxBase, Visual FoxPro, Clipper) query result to DB2 table.

save data from DBF  (dBase, xBase, FoxBase, Visual FoxPro, Clipper) query results to DB2  table - import

Transfer data from DBF query to DB2 in command line

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

Set scheduled tasks for transferring data from DBF query to DB2

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

1) Save session and create .bat (Windows) or .sh (Linux/macOS) file.

2) Set scheduled task.

FAQ


More about DBCopier DBF to DB2 Converter