Previous topic |
Next topic |
Contents |
Contact z/OS |
Library |
PDF
Counting values in a range z/OS DFSORT: Getting Started SC23-6880-00 |
|||
You can use ICETOOL's RANGE operator to count the
number of values
for a particular numeric field that fall within a range you define.
The range can be defined with:
The input data set defined by CADASD is the same data set you created earlier (with the SORT operator) for the California branches. HIGHER(-1500) indicates that you want to count values in the profit field that are greater than -1500, while LOWER(+8000) indicates that you want to count values in the profit field that are less than +8000. For a negative limit, you must specify a minus (-) sign before the number. For a positive limit, you either specify a plus (+) sign before the number or leave it out, therefore, HIGHER(8000) is the same as HIGHER(+8000). To print a count of the number of branches (in California and Colorado) with less than 32 employees, write the following RANGE statement: Because CADASD and ALL were previously defined, you don't need to add any new JCL statements to the ICETOOL job. When these RANGE operators are run, the results are placed in the TOOLMSG data set. The TOOLMSG output produced for these RANGE operators would look like this:
Looking at the
output, you will notice that:
|
Copyright IBM Corporation 1990, 2014
|