SQL Optimizer for DB2 LUW 4.3.1 - User Guide

Modify Data

When the data is display, a button bar appears at the bottom of the pane when you can edit the data. This button bar offers functions to view, edit, insert, and delete data.

To navigate through the data

• Use the scroll bar.

  or

• Use the navigator buttons. Depending on the amount of data, scrolling to the bottom of the page or executing the Last Record function may take sometime as all records needs to be retrieved from the database.

To edit a record

1. Place the cursor on the record you want to edit.

2. Click . You will be able to change the data for that record in the data grid.

3. Press the tab key or use the mouse to move to the next column. For LONG, CLOB, and BLOB data types, double-click the column to bring up the column edit window.

4. Once you have completed the modifications, click Commit or Rollback . 

To insert a new record

1. Place the cursor on the record on which you want to insert the new record before it .

2. Click .

3. Enter data for each column, press the tab key or use the mouse to move to the next column. For LONG, CLOB, and BLOB data types, double-click the column to bring up the column edit window.

4. Once you have completed entering the data, click Commit or Rollback .

To delete a record

1. Place the cursor on the record you want to delete.

2. Click .

3. When you click OK on the confirmation dialog the deletion will be automatically committed to your database.

To refresh the data

1. Click .

2. If an INSERT or UPDATE was not committed, you will be prompted to commit before the data is refreshed.

Note: You cannot update some views. A general rule is that any UPDATE, DELETE, or INSERT statement on a join view can be modified if only one underlying base table exists.

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.

Copy Data from Cells, Rows, or Columns

You can copy the data from a single cell, a row, or a column into the Windows clipboard from the Database Explorer and the Parameters windows.

To copy data

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 Data tab.
3. Highlight a cell with data.
4. Right-click and select Copy | Cell, Row, or Column.

View LONG, CLOB and BLOB Columns

You can view the data in a column that is a LONG, CLOB, or BLOB data type.

To view the data

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 Data tab.
3. Double-clicking the cell in the data grid.