Filter Tables for Nicknames -- Fields and controls

Use the Filter Tables for Nicknames window to define filter criteria for displaying table and view information in the Create Nicknames window.

Filter by

Operator

Values

Count

OK

Cancel

Filter by

Select the check box next to the item that you want to use as filter criteria. You can select one or both check boxes to define a filter on the Remote schema and Remote table name for data source tables and views.

Operator

Click the down arrow to display all SQL operator choices and select one. These SQL operators help you define your filter.

Values

Type the schema or table name that resides at the remote database. The value or values that you type are used as filter criteria. The values are case sensitive and need to follow certain syntax rules.

• Multiple values must be:
  • Separated by a comma
  • Delimited with a set of single quotes
  • Used in a IN or NOT IN statement
• In comparisons, you can:
  • Use the % wildcard character to match 0 or more characters.
  • Use the _ wildcard character to match exactly one character.

  For example: User ID like sm_th, Remote schema like BOB% and Remote table name = Sales 1.

Count

Click Count to view the number of tables that will be retrieved using your current filter criteria.

OK

Click OK to populate the Create Nicknames window with the tables and views that satisfy your filter criteria.