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:
- 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.
- 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.