Filters

<< Click to Display Table of Contents >>

Navigation:  Displays >

Filters

Previous pageReturn to chapter overviewNext page

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.

 

clip0075

 

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:

 

clip0076

 

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.

 

clip0106

 

 

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.