Export multiple similar DB2 tables to one SQL file

by

Posted on by

Want to export data from multiple similar DB2 tables to one SQL file?

Try Withdata DBToFile, a DB2 to SQL converter for Windows, Linux, and macOS, Export DB2 data to SQL, Easy and Fast.

Download Withdata DBToFile Download DBToFile

Export multiple similar DB2 tables to a single SQL file

Login to DB2 -> Select DB2 tables -> Set SQL file options -> Export DB2 to SQL

Choose DB2 and logon.

Export multiple similar DB2 tables to one SQL File - Choose DB2 and logon

Click “Export Similar Tables” at task dialog.

Export multiple similar DB2 tables to 1 SQL File - task window

Select SQL file type.

Export multiple similar DB2 tables to a single SQL File - select SQL file type

1. Select similar DB2 tables.

Unload multiple similar DB2 tables to 1 SQL File - select table

2. Set SQL file options.

Extract multiple similar DB2 tables to 1 SQL File - enter file name

3. Set rows options.

Convert multiple similar DB2 tables to 1 SQL File - summary

4. Export multiple similar DB2 tables to a single SQL file.

Dump multiple similar DB2 tables to 1 SQL File - export

After exporting, you can view output SQL file.

Export multiple similar DB2 tables to a single SQL File - view SQL file

More about DB2 to SQL converter

See also: