Open the data browser to view the contents of tables, materialized
query tables, views, aliases, and nicknames.
Before you begin
You can browse data only for DB2® for Linux®, UNIX®, and Windows® databases.
You must also have the authority to read the data.
Procedure
To open the data browser:
- In the Object List, right-click the
object with the data that you want to view.
- Click Browse Data in the context
menu.
Results
The data browser opens in the editor area of the workbench.
A title at the top of the browser indicates which object the data
is being displayed for. If filtering conditions have been set in the
Table
Data Filter dialog, the name of the object is appended
with the label
[Filtered].
What to do next
You can open multiple data browsers on the same or different
objects (tables, materialized query tables, views, aliases, and nicknames).
You can also filter the data or change the default for the maximum
number of rows that are retrieved and displayed.