Opening the data browser

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:

  1. In the Object List, right-click the object with the data that you want to view.
  2. 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.

Feedback