HP 3000 Manuals HP 3000 Manuals
USING SELECTION CRITERIA
When using the DISPLAY or the LIST command string, you can dictate the
listing you want to see by entering one of the Selection Criteria values
in response to a prompt. A listing can be chosen based on character
values, numeric values, or an expression of these values. In all cases,
the type of listing is based on the subcommand used.
You can enter a string of characters with a caret character (^) at the
end, beginning, or in the middle of the string. Depending on where used,
the caret has the following meaning:
* If used at the beginning of a string, it means that all values ending
with the string are to be listed.
* If used at the end of a string, it means that all values beginning
with the string are to be listed.
* If two carets are used at the end of a string, it means that all
values containing the string are to be listed.
* If embedded between characters in a string, it means that values that
match wherever characters appear in the string are to be listed.
You can also enter an expression of these values using the following
format:
[relationship] value connector [relationship] value ...
where:
relationship is an optional field that can contain one of the
following two letter codes:
NE not equal to
LT less than
LE less than or equal to
GT greater than
GE greater than or equal to
If a relationship is omitted, the default "equal to" is
used.
value connector is the Boolean connection between the values. The
following terms can be used:
TO the selected field must contain one of
a range of values where the low end of
the range precedes this connector and
the high end of the range follows this
connector.
AND the selected field must contain both
the value preceding and the value
following this connector.
OR the selected field must contain one or
both of the values.
The order of precedence is TO, then AND, then OR.
If the value to be selected contains one or more blanks,
then the value must be enclosed in quotation marks as
follows.
If you need more than one line for a selection
expression, end the first line with a connector, and
another selection line prompt is issued.
Examples
The following are examples of using carets and connectors:
PROD^ and ^NO Values that begin with PROD and end with NO are
selected.
ACCT^ or PROD^ and ^NO Values that begin with ACCT or values that
begin with PROD and end with NO are selected.
^FDCUST^ and ^NAME or Values that begin with CUST and end with NAME,
ACCT^ and ^NO or values that begin with ACCT and end with NO
are selected.
PROD^ or ACCT^ or CUST^ Values that begin with PROD or ACCT or CUST are
selected.
"PROD NO" Values that equal PROD NO are selected.
The following are examples of using relationship operators:
LT B Values which are less than values beginning
with B are selected.
GE R and LT V Values which are greater than or equal to
values beginning with R, and values which are
less than values beginning with V are selected.
GE M or I^ or LT C Values which are greater than or equal to
values beginning with M, or values which are
equal to values beginning with I, or values
which are less than values beginning with C are
selected.