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:
- 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.
- To add a schema filter, click Add in the Include schemas box.
The Add Schema Filter dialog box opens.
- 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.
- 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.
- Click OK. The filter element is added to the end of the Include
schemas table.

- To add an object filter, click Add in the include objects box.
The Add Object Filter dialog box opens.
- In the Target field, select the target database
object (such as table, view, alias) from the drop-down list.
- 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.
- 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.
- Click OK. The filter element is added to the end of the include
objects table.

- 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.
- 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.
- You can modify a filter by selecting a row in the table and
clicking Modify.
- You can delete a filter by selecting a row in the table and
clicking Remove.
- Click Finish to filter your new
database connection.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.