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
  1. Right-click a table in the Data Source Explorer, and click Data > Load.
  2. In the window that opens, specify the name and location of a .data file on the file system, and specify whether to replace existing data.
  3. Click Finish.
The data from the .data file is loaded into the table that you specified, and the results of the data load are displayed in the SQL Results view.
Related concepts
Characteristics of .data files
Data extraction and load limitations
Related tasks
Setting preferences for DB2 extract and load
Extracting data from a table or view to a .data file

Feedback