Online Documentation for SQL Manager for DB2

Specifying EXPORT destination


At this step you need to specify the destination of data to be exported and set filters for table selection.

 

Note: The step is available only if the EXPORT action was specified at the Specifying DB name and connection parameters step.

 

CLP Move - Specifying EXPORT destination

 

 

Extract to

Type in or use the ExplorerButton button to specify the path to the directory for exported data.

 

Path to LOB files

Type in or use the ExplorerButton button to specify the path to the directory for LOB files.

 

CheckBox Allow warnings

When disabled, tables that experience warnings during export are not included in the db2move.lst file (although the *.ixf file and *.msg files of those tables are generated anyway).

 

Filters

This group allows you to specify filters for selection of tables to be exported.

 

RadioButton Export all tables

If this option is selected, no filter will be applied, i.e. all available tables will be exported.

 

RadioButton Select tables manually

If this option is selected, you will be able to specify up to four additional filters (by definer, by table space, by schema, by table name), and to select tables at the next step of the wizard.

 

Use additional filters

This sub-group allows you to define additional filters for objects that will be available for selection at the next step. Available filters are:

CheckBox by definer

CheckBox by tablespace

CheckBox by schema

CheckBox by table name

 

Check/uncheck the boxes to enable/disable the filters. Use the editable area to specify filter criteria.

Note: You can use comma (,) as a delimiter for filter expressions. You can also use the asterisk (*) sign as a wildcard character that can be placed anywhere in the string when defining filters.

You can click the ellipsis EllipsisButton button to open the Additional filters dialog allowing you to manage the list of filters:

 

CLP Move - Additional filters

 

 

Type in a filter expression in the lower editable area.

 

The dialog allows you to Add, Replace and Delete filter conditions.

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

 

 

RadioButton Export tables listed in file

If this option is selected, the utility will export the tables that are listed in the specified file. Type in or use the ExplorerButton button to specify the path to the file using the Open dialog.

 

 

Click Next to proceed to the Selecting objects step of the wizard.