This paper is a mini-user guide for DFSORT’s versatile ICETOOL data objective is to show you how to use DFSORT’s ICETOOL to accomplish complex tasks. DFSORT is a powerful IBM utility used to copy, sort or merge datasets. SORTIN and SORTINnn DD statements are used to specify input datasets. SORTOUT and . Following Figure shows the Normal Layout of a ICETOOL job: // DFSMSG DD SYSOUT=* –> This is where the DFSORT messages.

Author: Akinonos Daikazahn
Country: Great Britain
Language: English (Spanish)
Genre: Medical
Published (Last): 27 August 2011
Pages: 125
PDF File Size: 14.13 Mb
ePub File Size: 18.5 Mb
ISBN: 754-3-83042-528-5
Downloads: 84525
Price: Free* [*Free Regsitration Required]
Uploader: Fenrikus

This will copy records from 1 to 99 and then the last record. Prints the number of records with value greater than Usually used to manage VSAM datasets.

A few of them are listed below with their functionality:. It gives best utilization of system resources and efficient operation in bit and bit address spaces.

Frequently used sort tricks using these utilities are explained in the next chapter.

JCL – Utility Programs

That is the values that appear only once. List indicates the output dataset.

For example, a file containing names of employees can be split into 26 files, each containing the names starting with A, B, C and so on. In the ON clause we can specify the format in which data will be displayed. This displays the count of records having field 36,2,ZD greater than Input and output datasets icetoool be defined using user defined DD names.


Create, delete, rename, catalog, uncatalog datasets other than PDS. ON indicates the fields to be displayed on the report.

IBM MAINFRAME: What exactly is ICETOOL utility & its usage

We could any of the existing masks. Also note that in the above figure the title is being printed every page. It can compare two or more files on specified field s and create icetol or more output files like file with matching records, file with non-matching records, etc. Thanx a lot Wolfgang.

ICETOOL Tutorial

Following can be used to remove duplicates from a file and save it to another file. TEXT is used to decide the text to be written before the count.

Ashwani Sharma 24 November at Above shows the unique values in the tutoriap 5,8,ZD. Above means keep tutroial records from input file from record numbers to Below prints the values that occur more than times. Prints the values that occur more than times.


Used to copy selected parts of a JCL. Usually, this is not recommended in view of performance for large files. Also note that both the titles are printed. Raj kumar Bhakthavachalam icdtool September at TLEFT to print the title left justified.

Only the header and trailer kept in place and rest of the data is sorted. Note the format is decided as follows: We can turn off that display using NOCC.

The ones that occur only 1 time are not printed. ON indicates the column for which unique must be found. Note that 1st column is occupied by the printing carriage control character. A File can be split into n files based on a specified condition. Posted by cobolbasics at See the Use of Edit patterns.

These utility programs need to be used with appropriate DD statements in a JCL in order to achieve the specified functionality.