Online Documentation for SQL Manager for DB2
CLP Export
CLP Export Data Wizard allows you to perform data export with the CLP export utility used.
The CLP export utility extracts data using an SQL select or an XQuery statement, and places that information into a file. You can use the output file to move data for a future import or load operation or to make the data accessible for analysis.
To run the wizard, select the Services | CLP Export main menu item, or right-click a database alias in the DB Explorer and select the Database Operations | CLP Export context menu item.
- Specifying DB name and connection info
- Specifying data destination
- Specifying DEL file modifiers
- Specifying LOB destination
- Specifying SQL SELECT statement
- Exporting 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: |