Filtering a Local Source

Creating filters for local sources is an easy way to add and change filters without making any changes on the mainframe. When you first create a local source, all of its data sets except for the restart data sets are included.

There are two approaches to filtering: Include all of the tables for a local source (the default) and then filter out the rows you don't need. Or, exclude all of the tables and use filtering conditions to pull in the rows you want. The appearance of the data set icon will change, depending on your selections (see Icon Descriptions).

This task is optional.

To filter local sources

  1. Right-click a local source and select an option to include or exclude all tables (data set).

    global dbenterprise linked file template

  2. Within the local source, filter a data set by right-clicking it and selecting one of the following:
    • Select the available options to include or exclude the data set. (Available options are determined by the status icon).
    • Select Edit WHERE filter to define a filtering condition in the Row Filter dialog box. Type a filtering clause in the WHERE box, or click data items and functions and then click the adjacent arrow to add them to the WHERE box.
  3. When the WHERE box reflects the filtering conditions you want, click OK.

    If the filter has no syntax errors, it is added to the data set (and the status icon changes to yellow).

  4. When you are finished creating filters, click Save to save your work.

After you set up filters, you can use a DATABridge Client to define, generate, and replicate a database using the Enterprise Server source.