<< Click to Display Table of Contents >> Filters |
![]() ![]() ![]() |
Filters are shown whenever you select a display from the workspace. The filter remembers the last entered values. It is not necessary to specify any search criteria here, but it is recommended, as it reduces the amount of data transferred from the server.
If you want to specify some search criteria, you must select an operator and a value. You can use wildcards configured in Basic General Options.
Date/Time fields support only an asterisk as a wildcard. This asterisk can be used instead of any date/time segment (year, month, day, hour, minute, second).
The value field is disabled when it has no sense (for instance for IS NULL operator).
You can combine more filters of the same field using logical operators (AND, OR). To add a new line of a field just click its title.
To remove it you can click the red x symbol.
In case of graphical displays you can also set the required predecessor and successor levels.
Fields requiring data in DATE or TIMESTAMP formats accept also these variables:
•TODAY
•YESTERDAY
•TOMORROW
If you enter only the variable, the date (in case of DATE format) or real time timestamp (in case of TIMESTAMP format) is used.
For timestamps you can combine both the variable and the time. For example, you can code "TODAY,15:30:00", which is transformed to 15:30:00 of the current date:
The filter supports one special operator IN SELECTION, which is available only when the filter is started when some table is active and has some lines selected.
In this case the value field changes a the select box where you can specify a column of the active table.
The filter uses values in the specified column of all selected lines in the active table as the search criteria. This saves you time for entering many '=' operators in some situations.
Currently you can select only 100 lines in the active table. More lines would produce too complicated SQL query.
Pressing the Actions button opens a menu with these functions:
Reset
Clears entered search criteria.
Reset from cursor
Clears entered search criteria starting from the field where you have a cursor to the bottom.
Show SQL
Shows the SQL based on entered search criteria. This SQL can be edited before submitting. It can also be saved in the same way as filters. You can't edit columns and table names if you are not connected to DB2 at z/OS. If you are connected to DB2 at z/OS and change some columns or tables then you always get a table display as a result, even when you have selected a graphical display from the workspace.
There is also Use Last SQL command, which replaces the current SQL by the last one used for the same display.
Load Filter
Loads saved filter from your profile.
Save Filter
Saves the loaded filter.
Save Filter As
Saves the filter with a new name.
Create shortcut...
Saves the filter as a shortcut.
Create selection file...
Saves the filter as .sel file that can be used in Scripts.
Create SQL file...
This command is available in Actions after you click Show SQL button. The command creates the selection file in SQL format and it can also be used in scripts.
If you are using multi-client support in your installation then SmartIS PC Client can automatically fill the extra columns with predefined values.
You can set it in your TCP file. Sample:
//----------------------------------------------
// TCP-IP Configuration file for PC Client
//----------------------------------------------
PORT=20000 // Port Number 20000-20001
IP_ADR=192.168.47.14 // P390NEW IP-Addres or Host-Name
MEMBER=XX35D#14 // TCP/IP Scheduler Member-Name (DD JCLLIB)
MULTI_CLIENT_VALUES=CLIENT,ENV,INFO
In this case the client is always set to CLIENT, environment is set to ENV and additional info is set to INFO. All these three columns are visible in the filter and are disabled.
All values must be defined without spaces.
The program does not check whether the server has multi-client enabled or not. If the values are defined then it always set the first three columns.