ICETOOL has 17 operators that are used to perform a variety of functions. The functions of these operators are summarized later in this section. See ICETOOL statements for more detailed information. Additionally, information pertaining to each operator is provided to calling programs that supply statements to ICETOOL using a parameter list. See Parameter list interface for details.

COPY

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

COUNT

Prints a message containing the count of records in a data set. COUNT can also be used to create an output data set containing text and the count, or 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 to an output data set.

DEFAULTS

Prints the DFSORT installation defaults in a separate list data set.

DISPLAY

Prints the values or characters of specified numeric or character fields in a separate list data set. Simple, tailored, or sectioned reports can be produced. Maximums, minimums, totals, averages and counts can be produced.

MERGE

Merges one or more data sets to one or more output data sets.

MODE

Three modes are available that can be set or reset for groups of operators:

• 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 ICETOOL statement checking without actually performing any operations.

OCCUR

Prints each unique value for specified numeric or character fields and how many 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 (for example, only duplicate values or only non-duplicate values).

RESIZE

Creates a larger record from multiple shorter records, or creates multiple shorter records from a larger record, that is, resizes fixed length records.

RANGE

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

SELECT

Selects records from a data set for inclusion in an output data set based on meeting criteria for the number of times specified numeric or character field values occur (for example, only duplicate values or only non-duplicate values). 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.

SPLICE

Splices together specified fields from records that have the same specified numeric or character field values (that is, duplicate values), but different information. Specified 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 for specified numeric fields in a data set.

SUBSET

Selects records from a data set based on keeping or removing header records (the first n records), relative records, or trailer records (the last n records). Records that are not selected can be saved in a separate output data set.

UNIQUE

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

VERIFY

Examines specified decimal fields in a data set and prints a message identifying each invalid value found for each field.