Filter parameter syntax
The filter parameter is used to limit the entries returned for a particular query. You specify a filter by listing a set of conditions. These conditions specify a comparison between two values; a subentry value in the CSI is compared with a fixed value specified in the condition.
Multiple filter conditions may be specified using the operators, & (logical AND) and | (logical OR). Parentheses may be used to group search conditions to ensure a desired evaluation sequence for the filter. The parentheses, when used, may be preceded by one or more blanks and also may be followed by one or more blanks.
When a subentry name represents a list of values, such as PRE, which is a list of all the prerequisite SYSMODs, each value in the list from the CSI is compared to the fixed value. If any match, the condition is evaluated as true.
- ASMIN
- HFSPARM
- HOLDDATA
- LECNTL
- LEPARM
- LMODALIAS
- LMODSYMLINK
- ORDERSERVER
- UTILPARM
- ZDESC
The fixed value must be enclosed within single quotation marks. Any set of characters may be used in the fixed value. If the fixed value is shorter than the subentry value, GIMAPI left-justifies the fixed value and pads it with blanks before doing the comparison.
Any apostrophes specified as part of a DESCRIPTION, VENDOR, or URL subentry (excluding delimiters) must be doubled. Double apostrophes count as two characters in the filter length.
Blanks may be freely used to separate the subentry, operator, and fixed value.
CIFREQ='PTF0001,PTF0002'
Refer to Valid subentry types for the format of each composite subentry type.
A null value for a subentry is specified by using two single quotation marks with no blanks between them(''). This can be used to find all entries whose value is not blank, for example, PATH!=''.
- Operator
- Function
- =
- Equal to
- !=
- Not equal to
- <
- Less than
- <=
- Less than or equal to
- >
- Greater than
- >=
- Greater than or equal to
- |
- Logical OR, at least one of two conditions are true
- &
- Logical AND, both conditions must be true
Subentry names that may appear to the left of operators are the subentries defined in Valid subentry types. Potential values for each subentry can be found in SMP/E data set entries. When a subentry is an indicator, such as PROTECT for the DDDEF entry, its value is either YES or NO.
- The subentry has not been set for the entry.
- The subentry does not apply to that entry.
When the not equal sign is used with some value within a filter,
for example SYSLIB!='MACLIB', the case where no data is found for
the subentry is considered a match, because MACLIB
does not
equal a null value. Therefore, if this filter is used when requesting
the SYSMOD entry type, all the SYSMODs in the selected zones are returned.
To exclude entries having no value, write the filter as (SYSLIB!='MACLIB' &
SYSLIB!='').
- HOLDDATE
- INSTALLDATE
- INSTALLTIME
- RC
- RECDATE
- RECTIME
- RESDATE
- RESTIME
- UCLDATE
- UCLTIME
The >, >=, < and <= operators have no meaning when applied to a subentry that has a null value. GIMAPI will always resolve such comparisons to false.
A date fixed value must use the format yyddd.
It must be five numeric characters. For example, specify 01365
to
represent December 31, 2001.
A time fixed value must use the format hh:mm:ss, where hh is a two-digit decimal number in the range 00 through 23, and mm and ss are both two-digit decimal numbers in the range 00 through 59. (That is, in 24-hour clock format.)
- Subentry name
- Operator
- Fixed value
- Conjunction (& or |)
- Left parenthesis
- Right parenthesis
- Filter part
- Can be followed by
- Subentry
- Operator
- Operator
- Fixed value
- Fixed value
- Conjunction, Right parenthesis, End of filter
- Conjunction
- Subentry Left parenthesis
- Left parenthesis
- Subentry, Left parenthesis
- Right parenthesis
- Conjunction, Right parenthesis, End of filter