Online Documentation for SQL Manager for DB2
CLP Load
CLP Load Data Wizard allows you to load data with the CLP load utility used.
The CLP load utility is capable of efficiently moving large quantities of data into newly created tables, or into tables that already contain data. The load utility is faster than the import utility, because it writes formatted pages directly into the database, while the import utility performs SQL INSERTs.
To run the wizard, select the Services | 
CLP Load main menu item, or right-click a database alias in the DB Explorer and select the Database Operations | CLP Load context menu item.
- Specifying DB name and connection info
- Specifying data source and destination
- Specifying common file modifiers
- Specifying advanced file modifiers
- Specifying action
- Specifying LOB source
- Specifying load parameters
- Specifying fields to load
- Specifying additional parameters
- Loading 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: |
