Mario,
I recommend running with trace so that you can find the exact statement that is failing.
There are a couple things that may cause the failure. First, there may be a problem with your syntax. I have put the Toolset Help for FILTER below for your reference. Second, I found in our problem database that the FILTER function does not support decimal precision attributes. The workaround is to use separate non-decimal precision attributes for the FILTER operations.
If this information does not help you resolve the problem, please open a case with CA Support.
FILTER
FILTER
FILTER displays selected items from a repeating group view in a list box. Items that do not meet the FILTER requirements are hidden from view. To redisplay hidden items, use UNFILTER.
The FILTER statement acts on the current contents of an export repeating group view. Once populated, the repeating group view can be filtered and unfiltered as many times as desired without rereading the database. Nested repeating group views are not supported.
Note: When using certain National Language Characters, the standard C sort routine called by the GUI FILTER statement may not yield desired results. You can define your own sort algorithm by modifying the String Compare User Exit WRSTRNCM. Refer to Chapter 12 of Implementation Toolset for z/OS User's Guide for more information on modifying user exits.
The format of a FILTER statement is:
FILTER repeating_group_view BY filter_character_expression
The repeating_group_view is an export repeating group view that includes a selection character.
Note: If you move the selection character with a repeating group view that has been filtered, the filtering will also be copied. If you do not want the filtering, do not move the selection character, or unfilter the view after if has been moved.
The filter_character_expression can be built using character functions, an entity attribute view, or character string.
When the filter_character_expression is true for an entry in the group view, the entry passes the filter and remains visible. When the expression is not true, the entry does not pass the filter and is not displayed.
Only items that pass the filter are included when the next filter expression is executed. An item that is hidden as a result of the first Filter statement is not included when subsequent Filter expressions are executed.
To build the filter_character_expression with a character string, you must know the order of attributes in the export repeating group view. Expand the list of views in the action diagram, or access View Maintenance to see the order in which attributes are listed. Attributes can be counted quickly in the View Maintenance window where an r identifies repeating group views and attr identifies attributes.
Consider only the attributes in the export repeating group view. Count the attributes sequentially, disregarding the fact that the attributes belong to different work sets or entities.
Note: Always include attributes of the supplied work set when counting views. An error results if SELECT_CHAR and other attributes of the supplied work set are overlooked when attributes are counted.
The filter argument is built on comparison expressions. A comparison expression consists of an attribute number, a required space, the comparison operator (=, >, <, etc.), a required space, and a comparison value.
For example,
"3 = 1994/01/28"
uses an equal condition to compare the third attribute with the date value January 28, 1994.
The comparison operators are:
= | equal to |
<> | not equal to |
< | Less than |
<= | Less than or equal to |
> | greater than |
>= | greater than or equal to |
Note: A space is required before and after comparison operators in a filter argument.
The data domain of the attribute and the data domain of the comparison value must be the same.
When the attribute domain is text, the comparison value must be a character string or a character view. If the character string contains a text constant, it must be enclosed in double quotation marks.
When the attribute domain is number, the comparison value must contain only numbers, sign characters, and decimal points, if needed.
When the attribute domain is date, the comparison value must be in one of the following formats.
YYYY/MM/DD or YYYY-MM-DD
When the attribute domain is time, the comparison value must be in one of the following formats.
HH:MM:SS or HH.MM.SS.
When the attribute domain is timestamp, the comparison value must be exactly 20 characters long with no decimal point, no colon, and no slash. The format of a timestamp is:
YYYYMMDDHHMMSSNNNNNN
Join two or more expressions to progressively limit the items in the list box. The operators AND and OR can be used to join two or more expressions. Also, parenthesis can be used to filter statements.
FILTER repeating_group_view BY (3 = engine)
If an invalid number of arguments are provided, a runtime error will occur.
Example
In the example below, the progression of FILTER expressions locates suppliers in Dallas or Houston with an ID above 10045. The suppliers that meet these criteria are filtered using subsequent expressions for the state and supplier type.
At the end of the event action, the UNFILTER statement reveals all rows in the repeating group view.
--EVENT ACTION filter_list | | --CASE OF COMMAND | +- CASE FILTER_CITY | | FILTER export_supplier_group BY "8 = "DALLAS" or 8 = "HOUSTON"" | +- CASE FILTER ID | | FILTER export_supplier_group BY "2 >= 10045" | +- CASE FILTER_STATE | | FILTER export_supplier_group BY "9 <> "TX" AND 9 <> "NY"" | +- CASE FILTER_TYPE | | FILTER export_supplier_group BY "5 = "S" OR 5 = "T"" | +- OTHERWISE | | UNFILTER export_supplier_group | -- --
The number 5 in the FILTER statement corresponds to the fifth attribute in the repeating group view EXPORT_SUPPLIER_GROUP shown below. The attributes are numbered in this example.
group (r) EXPORT_SUPPLIER_GROUP (50, implicit, export only) view of GROUPED_EXPORT (transient) wrk set SUPPLIED attr SELECT_CHAR view of GROUPED_EXPORT (transient) entity SUPPLIER attr ID <----- attr #2 attr NAME attr TELEPHONE attr TYPE <----- attr #5 attr STATUS attr ADDRESS attr CITY <----- attr #8 attr STATE <----- attr #9 attr ZIP attr TAX_ID attr COUNTRY_CODE attr COUNTRY attr GSA_NUMBER attr QUANTITY