Dictionary/3000 Reference Manual (32244-90001)

56 Chapter3
Using the DICTDBM Commands
Using Selection Criteria
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