Online Documentation for SQL Manager for DB2
CLP Import
CLP Import Data Wizard allows you to perform data import with the CLP import utility used.
The CLP import utility populates a table, typed table, or view with data using an SQL INSERT statement. If the table or view receiving the imported data already contains data, the input data can either replace or be appended to the existing data.
To run the wizard, select the Services | 
CLP Import main menu item, or right-click a database alias in the DB Explorer and select the Database Operations | CLP Import context menu item.
- Specifying DB name and connection info
- Specifying data source and destination
- Specifying common file modifiers
- Specifying advanced file modifiers
- Specifying LOB source
- Specifying fields to import
- Specifying additional parameters
- Importing data
|
Availability: |
|
|
Full version (for Windows) |
Yes |
|
Lite version (for Windows) |
No |
|
Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page. |
|
|
See also: |
