HP System Dictionary/XL SDMAIN Reference Manual (32256-90001)

3- 35
and Boolean operators.
Any keyword (or attribute qualifier in the ATTRIBUTE-LIST keyword) that is omitted (except for the
keyword flags) means that any value for that item is acceptable to you. For example, if displaying
attributes and TYPE = R is specified, but no LENGTH keyword is declared, the returned attribute is
accepted if it is a real value, regardless of its length. However, if LENGTH = 4 is specified, then only real
values of length 4 are returned.
Wild Card Characters. You can enter a string of characters with "wild card" characters embedded. The
"wild card" characters have the following meanings:
^ Match any 0 or more characters
! Match any SINGLE character
You can use the characters at any point within the character string. Additionally, you can use them in any
combination. For example, to specify that one or more characters are allowed in a particular position, you
can use an "!" for one character followed by a "^" for the additional characters.
Relational and Boolean Operators. Relational and Boolean operators are available and operate on
character or numeric values according to the following rules:
expression --> [expression connector] primary
primary --> [operator] value | (expression)
where | means OR
operator An optional field that can contain one of the following
relational operators:
= Equal to
<> Not equal to
< Less than
<= Less than or equal to
> Greater than
>= Greater than or equal to
If an operator is omitted, the default "= " (equal to) is used.
value A character string (with possible embedded wild card characters) or numericvaluetobe
compared to values retrieved from the dictionary.
If the value specified is rejected as a valid name in the dictionary (contains an illegal charac-
ter, blanks,or is longerthan 32characters),then itmustbe enclosedwithinquotation marks.
(See "User-Defined Names" in Chapter 3 for a description of valid and invalid characters.)
connector A Boolean connection between qualifying values. The following connectors are
allowed:
AND Selected field must contain both values.
OR Selected field must contain one or both values.
Operator Precedence. The order in which the selection criteria isprocessed is:
1 Operator qualifying the value