Filtering tables for creating nicknames

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 the list of tables that reside at the remote data source, clear all controls and click OK. This will cause all tables at the remote data source to be displayed in the Create Nicknames window.

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:

1. Specify a set of filter criteria to limit the number of tables that you want to create nicknames for.
   1. Select the check box next to the items in the Filter by column that you want to use in the filter.
   2. Use the Operator and Values columns to specify the filter criteria.
2. Optional: Click 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.
3. Click OK to use the filter criteria that you specified and to populate the Create Nicknames window.

[Return to main task]