You can use the workbench to extract the data from a relational
table or view into a file on the local file system. You can use this file
to load the data into a table.
Characteristics of .data files
You can use the workbench to generate a .data file. You can use
a .data file to load data into a table.
Setting preferences for extract and load
You can set preferences in the Preferences window for how DB2® data
is extracted and loaded, or how many rows are retrieved and displayed.