Export multiple similar DB2 tables to one TXT (pipe delimited text) file

by

Posted on by

Want to export data from multiple similar DB2 tables to one TXT (“|” pipe delimited text) file?

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

Download Withdata DBToFile Download DBToFile

Export multiple similar DB2 tables to a single TXT (“|” pipe delimited text) file

Login to DB2 -> Select DB2 tables -> Set TXT (“|” pipe delimited text) file options -> Export DB2 to TXT

Choose DB2 and logon.

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

Click “Export Similar Tables” at task dialog.

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

Select TXT file type.

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

1. Select similar DB2 tables.

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

2. Set TXT (“|” pipe delimited text) file options.

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

3. Set rows options.

Convert multiple similar DB2 tables to 1 TXT File - summary

4. Export multiple similar DB2 tables to a single TXT (“|” pipe delimited text) file.

Dump multiple similar DB2 tables to 1 TXT File - export

After exporting, you can view output TXT (“|” pipe delimited text) file.

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

More about DB2 to TXT converter

See also: