Export Table to Text for DB2 is a straightforward application designed to extract tables from databases and turn them into text, SQL, XML or Excel ready for databases. It features several approachable options.

The interface is made from a wizard, where you can begin by setting up a database connection in two ways: using a predefined data source (requires ODBC driver) or a direct connection to the server or database file (can be marked as a trusted connection). Apart from entering the user name and password, you can select the database and schema, as well as exclude any schemas from the task.

In the next wizard stage, you can pick the database table you want to take into account for the conversion operation after examining the name, schema and comment of each table.

It's possible to preview the data you're about to copy, execute queries, pick the target table or create a new one, append or replace data rows when using existing tables, copy data rows and indexes, copy or reset identity values from data rows, as well as include the table's indexes and primary key in the transfer.

Any columns may be added to the copy job too, and you can create a new table or export them to an existing one, as well as customize the column mapping or ask Export Table to Text for DB2 to do this automatically. Specific options can be configured for each output file type.

For instance, you can pick the values separator or set a fixed length for text, and choose a statement separator and target schema for SQL.

The tool worked smoothly in our tests, without hanging, crashing or showing error dialogs. It carried out tasks quickly and left a small footprint on system resources, using low CPU and RAM.

To wrap it up, Export Table to Text for DB2 offers an effective solution for extracting tables from databases to convert them to TXT, SQL, XML or Excel format.