Creating a Db2 object view
Use the following procedure to create a view in a workspace. Each view contains a subset of Db2 objects retrieved from a Db2 subsystem. This topic also explains how to build an advanced search to use as the basis for the new view.
To create a Db2 object view
- Open or create a workspace.
In the DB2 Navigator perspective, click the Add View
menu arrow, and then click Add DB2 Object Set View.Tip
The default value of the Add View menu is always the last option that you created. If you previously created a DB2 Object Set view, in this or a previous saved session, clicking
creates a new DB2 Object Set view.In the Add DB2 Object Set View dialog box, complete the following fields or accept the displayed default values:
Field
Action
DB2 Connection
Select a DB2 Connection from the list.
Tip: You can add DB2 connections to your list of favorite connections by clicking
and specifying which connections to include.Object Type
Select an object type.
Filter
Enter a filter pattern for the selected object type.
Click OK.
The view is now included in the DB2 navigation pane, in a hierarchical display organized by subsystem and type.
- When finished, save the workspace.
To build an advanced search clause for a view
The search clause is built from rows of search criteria in a grid. You can add, remove, and move rows to fine-tune the search clause.
As you enter the search criteria and build the search clause, the clause is displayed in the Search Clause text area below the grid.
- In the Add DB2 Object Set View dialog box, click Advanced search.
- Click Insert a row .
In the Add Expression dialog box, complete the following fields:
Field
Action
Column
Select a column name from the displayed list. The list includes all column names for the DB2 connection and object type.
Operator
Select an operator from the displayed list.
Value
Enter a value. The value is case sensitive and is automatically enclosed in the delimiter that you selected.
Logic
Select one of the following options:
- AND
- OR
- Click Save.
- Repeat steps 2 through 4 to continue adding rows until you have built the search clause.
(Optional) If you want to make any changes, edit the search criteria.Use the following buttons to add, edit, remove, or move rows. (You can perform the same operations by right-clicking in a row and selecting the appropriate command.)
Button
Description
Adds a row to the Search Clause criteria grid
In the grid, selecting a row and clicking
adds a row above the one that you selected.
Lets you Edit a row in the Search Clause criteria grid
Removes the selected row from the grid
Moves the selected row up
Moves the selected row down
You can also edit the search clause directly by typing in the search-clause text area.
You can use the following buttons:
Button
Description
Column
Click in the clause and, from the menu, select a column name to add to the search clause.
Operator
Click and, from the menu, select an operator to add to the search clause.
Click to discard any changes that you made in the text area and to re-synchronize the search clause with the search criteria in the grid. (Clicking this button again would restore your unsaved changes and disable the grid.)
- When finished building the search clause, click OK.
Related topic