SQL Optimizer for DB2 LUW 4.3.1 - Installation Guide

Copy Column Names to Another Window

To facilitate the construction of an SQL statement, copy the selected column names to the SQL Optimizer or SQL Formatter windows. A new line and a comma will separate each column name when it is copied to the editor pane of the other module.

To copy column names

1. Select the table or view name displayed on the tree diagram in the left pane of the Database Explorer window.

2. In the right pane, select the Column tab.

3. Select the column names by clicking the left-hand mouse button with the Shift or Ctrl key to select multiple columns.

4. Do one of the following:

   • Right-click and select Copy columns to SQL Optimizer.
   • Right-click and select Copy columns to SQL Formatter.