Data extraction and load

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.
Extracting data from a table or view to a .data file
Use the Extract Data window to extract the data from a table or view into a file on the file system.
Loading data from a .data file to a table
Use the Load Data window to load the data from a .data file into a table
Data extraction and load limitations
There are some limitations when you extract or load data from a .data file to a table using the workbench.