All the levels of filtering affect one single area,
the list of available tables that the SQL Wizard
(or the File Upload Wizard) displays at runtime.
Filtering determines which schema names and table
names appear in the list of available tables.
See List of available tables.
Summary of the levels of filtering
This section summarizes some of the characteristics of the
levels of filtering:
The person who implements the level of filtering.
The relationship of the level of filtering to the previous level.
Whether the level of filtering affects schemas, tables, or both.
The person who implements the level of filtering
is either the system administrator of the database,
the Host On-Demand administrator, or the user.
A level of filtering has one of the following two relationships
to the previous level of filtering:
It adds more filtering to the previous level; or
It overrides and replaces the filtering of the previous level.
A level of filtering may affect schemas, tables, or both.
The following table shows this information
for each level of filtering:
Level of filtering:
Person who implements:
Relationship to the previous level:
Affects schemas or tables:
1
System administrator
(No previous level)
Schemas and tables
2
Host On-Demand administrator
Adds further filtering to Level 1
Schemas and tables
3 (If enabled by the Host On-Demand administrator)
User
Overrides and replaces the filtering in Level 2
Schemas and tables
4 (If enabled by the Host On-Demand administrator)
User
Overrides and replaces the filtering in Level 3
Schemas and tables
5
User
Adds further filtering
Schemas
6
User
Adds further filtering
Tables
Description of the levels of filtering
Level 1. Database server
The system administrator controls system settings
that can prevent the user from seeing the names of
some schemas and tables.
Level 2. Table filter defined by the Host On-Demand administrator
Location:
For a Host On-Demand client:
The Table Filter field on the Tables tab
of the Data Transfer Defaults window in the session properties window
(not the session window)
of a 3270 Display session, 5250 Display session, or VT Display session.
For a Database On-Demand client:
The Table Filter field on the Tables tab
of the User Options window (or the Group Options window) in the Administration Utility.
Override option:
The administrator can allow the user to override and replace the filter value of Level 2:
For Host On-Demand clients,
enable the entry Edit Table filter
on the Edit Permissions tab of the Disable Functions window
(see Edit Table filter).
For Database On-Demand clients,
enable the entry Allow editing of Table filter
on the General tab of
the Database On-Demand Group Options window or
the Database On-Demand User Options window
(see Allow editing of Table filter).
Level 3. Default value for new SQL and File Upload statements for this user
Location:
For a Host On-Demand client:
The Table Filter field on the Tables tab
of the Data Transfer Defaults window in the session window
(not the session properties window)
of a 3270 Display session, 5250 Display session, or VT Display session
(Actions > Data Transfer Defaults).
For a Database On-Demand client:
The Table Filter field on the Tables tab
of the User Options window on the Database On-Demand client desktop.
Affects only the current SQL or File Upload statement.
Availability:
Always available.
Examples
Example 1
Level 1: In this example, there is no filtering in Level 1.
Level 2: The Host On-Demand administrator specifies
the following table filter:
IBMTEST%, HODTEST01.
This filter allows:
All schemas whose names begin with IBMTEST
(such as IBMTEST01, IBMTEST204, IBMTEST_RECAP, and so on)
and all tables within those schemas.
Schema HODTEST01 and all tables within it.
The administrator does not allow the user to override
the table filter.
Level 3: The Table Filter field for Level 3 is not displayed,
and therefore the user cannot override the table filter in Level 2.
Level 4: The Table Filter field for Level 4 is not displayed,
and therefore the user cannot override the table filter in Level 2.
When the user logs on to the database server,
the user sees only the schemas and tables
allowed by the filter in Level 2.
Level 5: The user can further narrow the List of available tables,
by moving schema names to the list of selected schemas.
Level 6: The user can further narrow the List of available tables,
by specifying table names in the table name filter.
Example 2
Level 1: In this example, there is no filtering in Level 1.
Level 2: The Host On-Demand administrator specifies
the following table filter:
IBMTEST%, HODTEST01.
This filter allows:
All schemas whose names begin with IBMTEST
(such as IBMTEST01, IBMTEST204, IBMTEST_RECAP, and so on)
and all tables within those schemas.
Schema HODTEST01 and all tables within it.
The administrator allows the user to override
the table filter.
Level 3: The Table Filter field for Level 3 is displayed.
The user overrides the table filter in Level 2 with
a new table filter value: %.
This new table filter value allows the user access
to all schemas and tables.
This new table filter value is the default value
for new SQL statements and File Upload statements
for this user.
Level 4: The Table Filter field for Level 4 is displayed.
The user overrides the table filter in Level 3 with
a new table filter value: IBMTEST%.
This new table filter value allows the user access
to all schemas whose names begin with IBMTEST,
and all tables within those schemas.
This table filter value applies only to the current
SQL or File Upload statement.
When the user logs on to the database server,
the user sees the schemas and tables
allowed by the filter in Level 4.
Level 5: The user can further narrow the List of available tables,
by moving schema names (such as IBMTEST01, IBMTEST204)
to the list of selected schemas.
Level 6: The user can further narrow the List of available tables,
by including table names in the table name filter.