Creating a filter for an iSeries database connection

Defining a filter speeds up the database connection process. You should create a filter to include only those tables that you want. Otherwise, all the tables on the iSeries server are included; this makes the database connection very slow. For iSeries, a system schema is a library and a table is a physical file.

Prerequisite: You can create a new JDBC connection filter only when you create a new database connection. After you have created the connection, you cannot change the filters. Read Creating an iSeries database connection first.
To create a new JDBC connection filter:
  1. In the New Database Connection wizard, click Next on the Specify connection parameters page to go to theLimit the objects retrieved from the database page.
  2. To add a schema filter, click Add in the Include schemas box. The Add Schema Filter dialog box opens.
  3. In the Predicate field, select either LIKE or NOT LIKE. The default is LIKE.
    • The LIKE predicate checks to see whether the data value in a column matches a specific pattern.
    • The NOT LIKE predicate checks to see whether the data value in a column does not match a specific pattern.
  4. In the Filter field, type the name of the filter. You can include one or more percent sign (%) wildcard characters in the JDBC connection filter. Note that the asterisk (*) wildcard character is not supported. Any target data objects that match the specified filter are either included or excluded, based on the value of the predicate.
  5. Click OK. The filter element is added to the end of the Include schemas table.
  6. To add an object filter, click Add in the include objects box. The Add Object Filter dialog box opens.
  7. In the Target field, select the target database object (such as table, view, alias) from the drop-down list.
  8. In the Predicate field, select either LIKE or NOT LIKE. The default is LIKE.
    • The LIKE predicate checks to see whether the data value in a column matches a specific pattern.
    • The NOT LIKE predicate checks to see whether the data value in a column does not match a specific pattern.
  9. In the Filter field, type the name of the filter. You can include one or more percent sign (%) wildcard characters in the JDBC connection filter. Note that the asterisk (*) wildcard character is not supported. Any target data objects that match the specified filter are either included or excluded, based on the value of the predicate.
  10. Click OK. The filter element is added to the end of the include objects table.
  11. After a filter element is defined, you can edit its properties to apply it to databases or schemas instead, and to make it an inclusion filter instead of an exclusion one.
    1. You can enable or disable a filter element from the filter tables by selecting or de-selecting the checkbox in the Enabled column for a particular filter element.
    2. You can modify a filter by selecting a row in the table and clicking Modify.
    3. You can delete a filter by selecting a row in the table and clicking Remove.
  12. Click Finish to filter your new database connection.