Adding a folder in the customized tree
Use the Add folder notebook to specify criteria and search a database object
for a name within the DB2 subsystem. Depending on where
you start your search from, you can find objects that exist
across the subsystem (selecting Locate from the subsystem folder),
or within a much narrower scope: inside the database, the table space,
or across tables and their supporting objects. Then you create a folder
based on this search and it becomes part of your customized tree.
Use the Locate page to specify search criteria and use the Advanced
page to further customize the search and verify your input.
Authorities
and privileges
To add a folder for your customized tree:
- Open the Locate notebook.
- In the Folder name field, type a string to identify your new folder.
- From the object type field,
select the type of database object for which to create a folder.
- On the Locate page, specify the search criteria:
- Use the Column ,
Comparison , and
Values fields to
specify criteria for up to five different catalog columns. Type some
value in at least one of the Values fields, including a
one-character wild-card (for an inclusive search). To search on all
objects, type the wild-card % in a field. The strings you type
in the values column will be folded to upper case unless delimited.
If you want to determine your subsystem's default delimiters, click
on your subsystem folder in the Control Center and right-click
on Display Subsystem Parameters.
Search for the macro DSNTIPF.
- Select a radio button to specify whether to meet all the conditions
selected in the fields on the Locate page, or meet at least one of the
conditions. Meet all conditions is equivalent to adding an and
between the search criteria, and Meet any conditions is equivalent to
adding an or between the search criteria.
- Click the Clear push button to erase the values you typed.
- Optional: Customize your search. Select the Advanced tab
to change the WHERE clause generated from your choices on the Locate page.
You can derive your own WHERE clause, or add more predicate columns to the existing clause.
- Click OK to use the search criteria that you defined.
The result of your search is displayed in a separate window.
- Click the Apply to repeat the search with the same or different criteria.
Related information