Previous Topic: PRTEXIT Command-Define a User ExitNext Topic: RUN Command-Begin Processing and Printing Reports

Commands › RANGE Command-Set Criteria to Include

RANGE Command-Set Criteria to Include

The RANGE command sets criteria that must be met before data is included in a report.

You can use the RANGE command only with Report Writer variables that have numeric values.

This command has the following syntax:

RANGE variable [RATE] min1-max1,min2-max2,..[ALONE][DEFERRED][ID rangeid]
                                            [UNDERLINE]
                                            [HIGHLIGHT]
variable

Includes any numeric Report Writer variable and then applies the range criteria to that variable.

RATE

Specifies range values as rates (number per second). RATE is valid only when DEFERRED is specified.

min1-max1, min2-max2, ...

Specifies up to 10 minimum and maximum values for the variable chosen. You can specify a single value, or a single value followed by a plus sign (+) to signify no upper boundary. Specifying a pair includes records when the specified variable value is greater than or equal to the minimum value and less than the maximum value.

ALONE

Applies only if multiple RANGE commands are used in a single report. If more than one RANGE command is used, all range criteria must be satisfied before a record is accepted. If one range value fails, the record is discarded.

When you specify the ALONE option on one RANGE command, and the record passes its range criteria:

DEFERRED

Waits to apply the range criteria until after all the input data is read, and then discards lines having values not meeting the range criteria. For example, only use the DEFERRED operand to report on only those jobs that were executed 10 or more times. The Report Writer is able to determine this criteria only after it reads all the input data. The RATE option is valid for the RANGE command when you use the DEFERRED operand.

UNDERLINE

Like the DEFERRED operand, waits to apply range criteria until after all the input data is read. However, instead of discarding lines not meeting the range criteria, the UNDERLINE option prints all lines and underlines those values that meet a range criterion.

HIGHLIGHT

Similar to UNDERLINE but prints values meeting the range criteria in boldface rather than underlining them. If you print the report on a laser printer, these values do not appear bold. In that case, use the UNDERLINE operand instead of the HIGHLIGHT operand.

ID rangeid

In a tabular report, assigns an identifier to the specified range of values for the variable. The range ID must be one to eight characters. You can use the GROUP command to specify a group that includes only those resources that fall within the range named rangeid.

Note: For more information, see GROUP Command in this chapter.

Examples: RANGE Command

To plot the activity of transactions with response times under one second, use the following commands:

PLOT TRAN USE
RANGE TERM RESP 0-1 DEFERRED
END
RUN

The following commands define groups by ranges of transaction lifetime and produce a report showing the average use and lifetime of each group:

GROUP TRANID RANGE:00.000-10.000(*) RANGE(TLIFE1)
 GROUP TRANID RANGE:10.001+(*)       RANGE(TLIFE2)
 RANGE TRAN LIFE 0-10     ID TLIFE1
RANGE TRAN LIFE 10-99999 ID TLIFE2
TAB TRANID(RANGE*) TRAN USE AND TRAN LIFE
END
RUN