The powerful ICETOOL basics the best alternative to DFSORT

Basics of ICETOOL
Basics of ICETOOL

What is ICETOOL

ICETOOL, a versatile data set processing and reporting utility, provides an easy-to-use batch front-end for DFSORT.

How to use ICETOOL

ICETOOL combines new features with previously available DFSORT features to perform complex sorting, copying, reporting, join, match and analytical tasks using multiple data sets in a single job step.

Also Read: Sorting Multiple Fields in DFSORT

Major operators in ICETOOL :
COPY – copies a data set to one or more output data sets. Multiple output is handled using a single pass over the input.

COUNT – prints a message containing the count of records in a data set. Can also be used to set RC=12, RC=4 or RC=0 based on the count of records in a data set (that is, empty, not empty, higher, lower, equal or not equal).

DEFAULTS – prints the DFSORT installation defaults in a separate list data set.

DISPLAY – prints the values and characters of specified numeric and character fields in a separate list data set. Simple, tailored or sectioned reports can be produced.

MODE – sets/resets scanning and error actions.

OCCUR – prints each unique value for specified numeric and character fields, and the number of times it occurs, in a separate list data set. Simple or tailored reports can be produced. The values printed can be limited to those for which the value count meets specified criteria (that is, all duplicates, no duplicates, higher,
lower or equal).

RANGE – prints a message containing the count of values in a range (that is, higher, lower, equal or not equal) for a numeric field.

SELECT – selects records for an output data set based on meeting criteria (that is, all duplicates, no duplicates, first, last, first duplicate, last duplicate, higher, lower or equal) for the number of times numeric or character field values occur. Records that are not selected can be saved in a separate output data set.

SORT – sorts a data set to one or more output data sets. Multiple output is handled using a single pass over the input.

SPLICE – splices together fields from records that have the same numeric or character field values (that is, duplicate values), but different information. Fields from two or more records can be combined to create an output record. The fields to be spliced can originate from records in different data sets, so you can use SPLICE to do various “join” and “match” operations.

STATS – prints messages containing the minimum, maximum, average, and total of values in numeric fields.

UNIQUE – prints a message containing the count of unique values in a numeric or character field.

VERIFY – prints a message identifying each invalid value found in decimal fields.

Advertisements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.