Use the Filter Tables for Nicknames window to define a set of criteria for
displaying tables in the Create Nicknames window. If you don't
want to filter tables that reside at the data source, click Retieve All. This will cause all tables at the
data source to be displayed.
| Important: | The time required to populate the Create Nicknames window greatly increases
with the number of tables that you retrieve.
|
These steps are part of the larger task of creating nicknames. When
you complete the steps for filtering tables, return to
creating nicknames.
Fields and controls
To define a filter for tables:
- Specify a set of filter criteria to limit the number of tables that you
want to create nicknames for.
- Use the Column, Comparison and Values fields to specify the criteria to filter the
tables based on values for User ID, Remote schema and Remote table
name.
- Select a radio button to specify the conditions for filter.
Meet all conditions is equivalent to adding an and
between filter criteria, and Meet any conditions is equivalent to
adding an or.
- Click Preview Table Count to view the
number of tables that will be returned based on your filtering
criteria. If the number is not acceptable, return to step 1 and try
setting new criteria.
- Click Apply Filter to use the filter
criteria that you specified and to populate the Create Nicknames
window.
[Return to main task]