Viewing data in the table data editor in read-only mode

Open the table data editor in read-only mode to view the contents of a table, view, alias, materialized query table, nickname, or synonym. When you view the data in read-only mode, you cannot edit the data.

Before you begin

You can view the data in these objects for DB2® for Linux, UNIX, and Windows Version 9.1 and later and for DB2 for z/OS® Version 9 and later. You must have the appropriate privileges to select data.

Procedure

To view data in the table data editor in read-only mode:

  1. In the Administration Explorer, click a folder to display the list of objects in the Object List. For example, click the Tables folder to see the list of tables.
  2. In the Object List, right-click an object and click Browse Data in the context menu.

    The table data editor opens in the editor area of the workbench. The title at the top of the table data editor editor indicates the name of the object. If filtering conditions have been set in the Table Data Filter dialog, the name of the object is appended with the label [Filtered].

    For columns that have a LOB data type or any user-defined data type that is based on a LOB data type, you can view only the first 100 bytes of the data.

What to do next

You can open multiple table data editors on the same or different objects. You can also filter or refresh the displayed data.

Feedback