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

3- 36
2 Expressions enclosed in parentheses
3 AND
4OR
Examples. The following are examples showing the use of selection criteria.
PROD^ and ^NO Values that begin with PROD and end with NO are selected.
PROD^ or ^ACCT^ Values that begin with PROD or contain ACCT somewhere in them are selected.
A^Z Values that begin with an A and end with a Z with any number of any characters be-
tween are selected.
M!! Values that consist of M followed by any two characters are selected.
A!^ Values that consist of A followed by one or more characters are selected.
<= B or >= Y Values that are less than or equal to B or are greater than or equal to Y are selected.
45 or > 60 Values that are equal to 45 or are greater than 60 are selected.
E^ OR G^ AND ^D Values that begin with an E or that begin with a G and end with a D are selected.
(E^ OR G^) AND ^D Values that begin with an E or a G and end with a D are selected.
(10) OR (<15 AND >12) Values that are equal to 10 or are between 12 and 15 are selected.
Example
The following example illustrates the use of System Dictionary reporting commands:
>DEFINE DICTIONARY Opens the dictionary in exclusive-update mode in the
>>SCOPE = data-administrator; latest production version of the common domain.
>>PASSWORD = da;
>>OPEN-MODE = exclusive-update.
>CONFIGURE OUTPUT = rptfile. Configures the output environment with rptfile as the output file.
>DISPLAY ENTITY-TYPE terminal. Displays the entity-type terminal.
>DISPLAY ATTRIBUTE a^; Lists the names of all attributes beginning with the letter "a" .
>>NAME-ONLY.
>START Marks the beginning of a report definition. Command execution is disabled until the
SAVE command is encountered, marking the end of the report definition.
>CONFIGURE Specifies a 15-space right margin and a 10-line top margin, when
>>RIGHT = 15; output is directed somewhere other than the terminal.
>>TOP = 10.
>REPORT ENTITY; The reporting command that defines what information appears on the report.
>>ENTITY-TYPE = element. In this case, the report provides information on all entities of entity-type
element.
>SAVE element-report; Saves the report with the name element-report and an appropriate