The
following 17 ICETOOL
operators can be used to perform a variety of functions. By using
various combinations of the
17 ICETOOL operators,
you can easily create applications that perform many complex tasks.
- 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 (for example, empty, not empty, less than, equal to,
or greater than 5000 records, and so on).
- 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, which 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).
- RANGE
- Prints a message containing the count of values in a specified
range for a specified numeric field in a data set.
- RESIZE
- Creates a larger record from multiple shorter records, or creates
multiple shorter records from a larger record, that is, resizes
fixed length records.
- 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, relative records or trailer 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.