Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.4.1 - Installation 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.

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.

 

Related Documents