In this topic, we described about the Operations with detailed example.
ICETOOL is a multipurpose DFSORT utility. ICETOOL uses the DFSORT capabilities to perform multiple operations in a single step on one or more data sets. Below are the 17 ICETOOL operators used to perform a variety of functions.
Copies one data set to one or more output data sets. Multiple outputs are handled using a single pass over the input.
Prints message in TOOLMSG containing the records count in a data set. COUNT used to create an output data set containing text and the count. COUNT used to set RC=12, RC=8, RC=4 or RC=0 based on meeting criteria for the number of records in a data set.
Sorts data records between header and trailer records in a data set. Copies all records along with sorted records to an output data set.
Prints the DFSORT installation defaults in separate list data set.
Prints the specified numeric or character fields values in separate list data set. Can produce simple, tailored or sectioned reports. Can produce maximums, minimums, totals, averages and counts.
Merges one or more input data sets into one or more output data sets.
Error checking and specifies the actions after error detection to be performed for a group of operators. Three modes are available to set or reset for operator’s groups -
- STOP mode (the default) stops subsequent operations if an error is detected.
- CONTINUE mode continues with subsequent operations if an error is detected.
- SCAN mode allows to check ICETOOL statement without performing any operations.
Prints each unique value for specified numeric or character fields and how many times it occurs in a separate list of the data set. Can produce simple or tailored reports. The printed values can be limited to value count that meets specified criteria.
Prints a message containing the values count in a specified range for a specified numeric field in a data set.
Creates a larger record from multiple shorter records if the record length is smaller than specified length. Creates multiple shorter records from a larger record if the record length is larger than specified length.
Selects records from a data set for inclusion in an output data set based on meeting criteria. The selection criteria for the number of times of the specified numeric or character field values that occur. Not selected records can be saved in a separate output data set.
Sorts a data set and copies it to one or more output data sets.
Joins together specified fields from records that are having the same specified numeric or character field values (duplicate values) but with different information.
Specified fields from two or more records can be combined to create an output record. The fields to be joined can originate from records in different data sets.
Prints messages containing the minimum, maximum, average and total for specified numeric fields in a data set.
Selects records from a data set based on keeping or removing header records, relative records or trailer records. Not selected records can be saved in a separate output data set.
Prints a message containing the unique values count for a specified numeric or character field.
Examines specified decimal fields in a data set. Prints a message identifying each invalid value found for each field.