Online Documentation for SQL Manager for DB2

Specifying data source and destination


At this step you need to specify the data source and destination table for the load operation.

 

CLP Load - Specifying data source and destination

 

 

Source

 

Data location

Use the drop-down list to select the source data location: Client location, Server location, Statement, TSM (Tivoli Storage Manager) media, or Other.

 

Specify a list of source files, devices, vendors, pipes, or SQL statements

Type in or use the ellipsis EllipsisButton button to specify the list using the corresponding Specify a list... dialog.

 

CLP services - List of source files

 

 

Type in a path in the lower editable area or use the ExplorerButton button to specify the path to the file using the Open dialog.

 

The dialog allows you to Add, Replace and Delete paths.

You can also reorder items in the list with the help of the btnMoveUp_blue btnMoveDown_blue buttons.

 

 

Destination for error, warning, and informational messages returned by the utility

Type in or use the btnSaveAs button to specify the path to the file and the file name.

 

 

File type

Select the type of the data source file. Supported file types are:

Delimited ASCII (*.del)

Non-delimited ASCII (*.asc)

Integration Exchange Format (*.ixf)

 

 

Destination

This section allows you to define destination for loading data. Use the Schema and Table drop-down lists to specify the schema and table into which the data are to be loaded.

 

 

Click the Next button to proceed to the Specifying common file modifiers step of the wizard.