Use the Database Explorer to select an existing query
The Database Explorer opens in the Explorer window when
QMF for WebSphere opens. You can use the Database Explorer to view,
access, and analyze QMF objects that reside on the database servers
that have been defined in the SDF.
Navigating the Database Explorer tree
The Database Explorer displays in a tree structure the
QMF objects that are stored on the database servers to which you
have access. The Database Explorer tree contains four branches:
Favorites
The Favorites branch lists the QMF
objects that you have selected for inclusion. You can move any QMF
object listed in the Database Explorer branches to the Favorites
folder by selecting the object and dragging it to the folder. You
can also right-click on the QMF object and select Add to Favorites from
the context menu. The Add to Favorites window
opens where you can add the object to your Favorites branch.
Recently Used Objects
The Recently Used Objects branch
lists the database objects that you have used during your the QMF
for WebSphere session in the order that you have used them. QMF
for WebSphere keeps track of your object usage during the session.
The list is updated each time that you use an object. You can specify
the number of QMF objects that are included in the list by selecting View--> Options and
clicking the Database Explorer Options page.
Recently Used Servers
The Recently Used Servers branch
lists the database servers that you have used during your last QMF
for WebSphere session in the order that you have used them. QMF
for WebSphere keeps track of your server usage during the session.
The list is updated each time QMF for WebSphere is restarted. You
can specify the number of servers that are included in the list
by clicking View--> Options and clicking
the Database Explorer Options page.
All Servers
The All Servers branch lists all
the database servers that have been defined in the SDF. You can
expand each database server by clicking the (+) to the left of the
server name. QMF for WebSphere retrieves and lists all the QMF objects
that are stored on that database server. To select what objects
should be included in the list, right-click on a database server
in list and select Filter from the context
menu. The Filters window opens
Using the Database Explorer
You can use the database Explorer to:
- Run or display a QMF object by double clicking on the object
listed in any of the branches of the Database Explorer tree. By
default, double clicking on the OMF object will run the object.
To display the object by double clicking, you must select View--> Options and
select the Database Explorer page where you can change the default
from Run to Display.
- Right-click on any database server listed in the Database Explorer
tree and open a context menu. From the context menu you can select Set Name Filter or Set Type Filter to
open the Filters windows where you specify which QMF objects will
be included in the database server branch in the Database Explorer
tree. You can select New Document and choose
to create a new Query, OLAP query or Procedure. You can also choose
to Refresh the list of objects that are available
for the selected database server.
- You can right-click on any object listed in the Database Explorer
tree and open a context menu. From the context menu you can Open,
Run, Delete, and Rename the object. If applicable to the selected
object, you can access the add the object to your Favorites folder
or view Properties.
- You can view all of a QMF object's dependencies on other objects
from the Database Explorer tree. All query objects, including procedures,
listed in all of the Database Explorer branches, have a single child
node that is labeled References. Expand the query object by clicking
the (+) to the left, and then expand the branch References by clicking
its (+) expand icon. The Object Analyzer is invoked. An analysis
is triggered to determine the selected object's dependencies. All
reference objects will display beneath the References nodes. All
operations that can be performed on objects listed in the Database
Explorer branches, can also be performed on these objects.
- If you select a table, the Object Analyzer will list the columns.
The child node name is Columns. Expand the table object by clicking
the (+) to the left, and then expand the branch Columns by clicking
its (+) expand icon. The Object Analyzer is invoked. An analysis
is triggered to determine the selected table's columns. All table
column names will display beneath the Columns branch.
