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: Gorn Zuzuru
Country: Malawi
Language: English (Spanish)
Genre: Education
Published (Last): 27 April 2017
Pages: 95
PDF File Size: 15.83 Mb
ePub File Size: 6.22 Mb
ISBN: 742-4-39638-703-7
Downloads: 60613
Price: Free* [*Free Regsitration Required]
Uploader: Nam

Complete ICETOOL examples

Is for formatting purpose. Note the format is decided as follows: See the Use of Edit patterns.

Matthew McKenzie 8 August at 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.

A few of them are listed below with their functionality:. Above means keep the records from input file from record numbers to The string within is also printed before the value is printed. Thanx a lot Wolfgang. In the ON clause we can specify the format in which data will be displayed. Note that 1st column is occupied by the printing carriage control character.


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

Complete ICETOOL examples

A File can be split into n files based on a specified condition. TLEFT to print the title left justified. We can specify NOCC to override default of printing carriage control characters. Numeric fields with usage COMP Used to copy selected parts of a JCL.

Note that only the column we mentioned in ON is printed in the report. List indicates the output dataset. Above shows the unique values in the column 5,8,ZD. The ones that occur only 1 time are tutorual printed. It is usually used to create empty dataset or delete an existing dataset.

Usually, this is not recommended in view of performance for large files. Prints the number of records with value greater than We could any of the existing masks. Also note that both the titles are printed.

This will copy records from 1 to 99 and then the last record. ON indicates the column for which unique must be found. Utility programs are pre-written programs, widely used in mainframes by system programmers and application developers to achieve day-to-day requirements, organising and maintaining data.

Using the ICETOOL utility

This tutoriap us a sample records for testing. Also note that in the above figure the title is being printed every page. Raj kumar Bhakthavachalam 4 September at This prints the values that occur more than once.


Used to return control to user and terminate. Input and output datasets can be defined using user defined DD names.

Posted by cobolbasics at Below prints the values that occur more than times. Frequently used sort tricks using these utilities are explained in icefool next chapter.

Using the ICETOOL utility

Only the header and trailer kept in place and rest of the data is sorted. It can compare two or more files on specified field s and create one or more output files like file with matching records, file with non-matching records, etc.

That is the values that appear only once. Following can be used to remove duplicates from a file and save it to another file. Prints the values that occur more than times. Create, delete, rename, catalog, uncatalog datasets other than PDS. Numeric fields with usage COMP: