Online Documentation for SQL Manager for DB2

Selecting objects to export/copy


Use this step of the wizard to select objects to be exported/copied.

 

Note: The step is available only if the EXPORT or COPY action was specified at the first step, and the RadioButton Select tables manually option was selected at the Specifying EXPORT destination/Specifying COPY destination step.

 

CLP Move - Selecting objects

 

 

The Available tables list displays the tables with names satisfying filter criteria set at the previous step (Specifying EXPORT destination / Specifying COPY destination) as a grid with the following columns: Table name, Definer, Tablespace, Schema. If more convenient, you can change the order of the columns by dragging their headers horizontally.

 

Click a column caption to sort items by values of this column in the ascending or the descending mode.

 

If necessary, you can group the data in grid by any of the columns. This operation is performed by dragging the column header to the gray "Group by" box area at the top. When grouping by a column is applied to the grid, all the rows are displayed as subnodes to the grouping row value. To reverse grouping, just drag the column header back.

 

To select an object, you need to move it from the Available tables list to the Selected tables list. Use the Move all to Selected Move to Selected Move to Available Move all to Available buttons or drag-and-drop operations to move the objects from one list to another.

 

 

Click Next to proceed to the Specifying COPY options step of the wizard (for the COPY action), or directly to the Moving data step (for the EXPORT action).