Host Explorer Filters

Host Explorer filters are used to define a subset of resources, such as mainframe or local files and databases, to view in the Host Explorer view. For example, a z/OS dataset filter of userid.* will add datasets beginning with userid to the Host Explorer view. The following resource types can be viewed and filtered in the Host Explorer view:

• Endevor
• File-AID for DB2
• File-AID for IMS
• z/OS UNIX files
• z/OS datasets
• z/OS GDG datasets
• Local file system
• Configured remote relational databases

To add a mainframe filter

1. Do one of the following:
   • For Endevor, refer to the instructions for adding a filter in Endevor.
   • For File-AID for DB2, refer to the instructions for accessing DB2 data in the Topaz Workbench File-AID/Eclipse User Guide.
   • For File-AID for IMS, refer to the instructions for accessing IMS data in the Topaz Workbench File-AID/Eclipse User Guide.
   • For z/OS UNIX files, refer to the instructions for adding a filter for z/OS UNIX files.
   • For z/OS datasets, continue with the steps belo
2. In the Host Explorer view, right-click the z/OS datasets resource type and select Add Filter. The Filter dialog box appears.

3. Enter the filter, which can be a complete name, such as USERID.SRC, or a name wildcarded with the asterisk character. Some examples include the following:

   • 
     
     • HLCOBOL.SOURCE (all datasets beginning with qualifiers HLQ.COBOL.SOURCE)

   • 
     
     • HL*.SOURCE (single asterisk to represent a single qualifier)
     • HL**.SOURCE (double asterisk to represent multiple qualifiers)
     • HLCO%OL.SOURCE (percent sign to represent a single character)
     • HLCOBOL.SOURCE(A*) (asterisk to represent one or more characters in a member name)
     • HLGDG.BASE(-1) (a number to represent a specific generation of a GDG)
4. Click OK to add the filter. The filtered results display all of the resources on the system that match the filter.

To add a local file system filter

1. In the Host Explorer view, expand the machine name.
2. Right-click the resource type Drives and select Add Filter. The Filter dialog box appears.
3. Enter the filter, which can be a specific drive on the local machine or can include folder names (for example, C, D:\temp, or D:\temp\misc). The main folder level must be fully specified, including drive letter. Subfolders may be partially named.
   
   Wildcarding can be achieved by leaving off trailing characters of a file or subfolder name. For example, D:\temp\file will list all of the files in the temp folder starting with file. A filter containing a partially named subfolder will list matching folders and also any matching files at that level.
4. Click OK to add the filter. The filtered results display all of the resources that match the filter

To add a filter for a remote relational database

As an optional, licensed feature or when File-AID Services is defined in your preferences, may you see Database hosts. These defined Database hosts appear as a host in the Host Explorer view.

1. In the Host Explorer view, expand the host.
2. Right click Database type or Creators and select Add Filter. The Filter dialog box appears.
3. Enter the filter, including a full schema name, partial schema name followed by asterisk, or just an asterisk. Then fill in full table/view name, a partial table/view name followed by asterisk, or just an asterisk. For example:

• 
  
  • Schema=* Table=* (list all table/views in all schemas)
  • Schema=d* Table=A* (list all tables/views beginning with "A" in all schemas beginning with "d")
  • Schema=dbo Table=* (specific schema, list all tables/views)
  • Schema=dbo, Table=A* (specific schema, list all table/views beginning with A)

To edit and delete filters

Filters can be edited by right-clicking the filter, selecting Edit, and making changes in the Filter dialog box that appears.

Filters can be deleted by right-clicking the filter and selecting Delete Filter.