This paper is a mini-user guide for DFSORT’s versatile ICETOOL data objective is to show you how to use DFSORT’s ICETOOL to accomplish complex tasks. You can change the DFSORT or ICETOOL control statements and job steps to create reports for your installation. Consider these things that you can do to the. Complete ICETOOL job and TOOLMSG output. Here is the complete ICETOOL job you created in this chapter: Figure 1. Complete ICETOOL Job (Part 1 of 2).

| Author: | Felar Voodoogal |
| Country: | Cambodia |
| Language: | English (Spanish) |
| Genre: | Career |
| Published (Last): | 16 July 2013 |
| Pages: | 30 |
| PDF File Size: | 12.17 Mb |
| ePub File Size: | 20.60 Mb |
| ISBN: | 606-2-71054-200-4 |
| Downloads: | 98350 |
| Price: | Free* [*Free Regsitration Required] |
| Uploader: | Tojam |
The output records would look like this: Iibm 1 shows the Book Title and Publisher fields for the records in the resulting output data set.
NODUP is the ddname of the output data set to contain the records for courses with only one book. To create separate output data sets containing records with only the course name and author’s last name, both for courses that use more than one book, and for courses that use only one book, write the following SELECT statement: The selected records are written to the output data set identified by the TO operand. Here is the complete JCL for the job, including control statements: Here are the DUP records exactly as they would appear: BKIN is the ddname for the sample bookstore data set.
Inm a DD statement for the A You can select different combinations of records with duplicate and non-duplicate values using the following operands: BOOKS1 data sets and place it at the end of the job:. The intermediate result would be: Icetlol far in this chapter you have learned how to print statistics for numeric fields, create sorted and unsorted data sets, obtain a count of numeric fields in a range for a particular field, print fields from an input data set, print reports, print a count of field occurrences and select output records based on field occurrences.
Suppose you want to use the SORT.

DUP is the ddname of the output data set to contain the records for courses with more than one book. As with the OCCUR operator, values that occur only once are called non-duplicate values, and values icetool occur more than once are called duplicate values.
Using DFSORT’s ICETOOL
This brings the records for each state with the highest number of employees to the top. The actual records contain all of the fields.
To create an output data set containing records for publishers with more than four different books in use, write the following SELECT statement: The SORT statement orders the records ascending by state and descending by number of employees. You can use up to 10 ON fields; all of the ON field values are used for sorting and icetkol occurrences.
