Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.4.1 - User Guide

SQL Optimizer for IBM® DB2® LUW
UsageStatistics Getting Started Options SQL Scanner SQL Optimizer SQL Formatter SQL Inspector Database Explorer SQL Repository Index Impact Analyzer Index Usage Analyzer User-Defined Temp Table Editor Functions SQL Functions SQL Information and Functions Activity Log
Tutorials About us Copyright

Sort Criteria

The current schema is presented as the first item of the Database Objects tree followed by the remaining names in alphabetical order.

 

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.

image\BB_ModifyData.gif

To navigate through the data

  • Use the scroll bar.

    or

  • Use the navigator image\B_EditNaviagte.gif 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 image\B_EditRecord.gif. 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 Commitimage\B_EditCommit.gif or Rollback image\B_EditRollback.gif

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 image\B_EditInsert.gif.

  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 image\B_EditCommit.gif or Rollback image\B_EditRollback.gif.

To delete a record

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

  2. Click image\B_EditDelele.gif.

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

To refresh the data

  1. Click image\B_EditRefresh.gif.

  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.

 

Related Documents