ICETOOL - Operations


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.


COPY

Copies one data set to one or more output data sets.

Multiple outputs are handled using a single pass over the input.


COUNT

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.


DATASORT

Sorts data records between header and trailer records in a data set.

Copies all records along with sorted records to an output data set.


DEFAULTS

Prints the DFSORT installation defaults in separate list data set.


DISPLAY

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.


MERGE

Merges one or more input data sets into one or more output data sets.


MODE

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.

OCCUR

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.


RANGE

Prints a message containing the values count in a specified range for a specified numeric field in a data set.


RESIZE

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.


SELECT

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.


SORT

Sorts a data set and copies it to one or more output data sets.


SPLICE

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.


STATS

Prints messages containing the minimum, maximum, average and total for specified numeric fields in a data set.


SUBSET

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.


UNIQUE

Prints a message containing the unique values count for a specified numeric or character field.


VERIFY

Examines specified decimal fields in a data set.

Prints a message identifying each invalid value found for each field.