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.

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 button to specify the list using the corresponding Specify a list... dialog.

Type in a path in the lower editable area or use the 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 buttons.

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

Type in or use the 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.