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: Sharamar JoJolkree
Country: Guinea-Bissau
Language: English (Spanish)
Genre: Relationship
Published (Last): 11 November 2014
Pages: 368
PDF File Size: 9.1 Mb
ePub File Size: 13.25 Mb
ISBN: 424-1-99905-799-5
Downloads: 61214
Price: Free* [*Free Regsitration Required]
Uploader: Brami

Above shows the unique values in the column 5,8,ZD. It is usually used to create empty dataset or delete an existing dataset.

JCL – Utility Programs

Prints the number of records with value greater than Frequently used sort tricks using these iectool are explained in the next chapter.

We can specify NOCC to override default of printing carriage control characters. Is for formatting purpose. That is the values that appear only once.

TEXT is used to decide the text to be written before the count. Thanx a lot Wolfgang. ON indicates the column for which unique must be found.

Using the ICETOOL utility

The string within is also printed before the value is printed. A File can be split into n files based on a specified condition. Note that only the column we mentioned in ON is printed in the report. Above means keep the records from input file from record numbers to All unique records will be copied to another datasets.


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. Usually used to manage VSAM datasets. The ones that occur only 1 time are not printed.

Below prints the values that occur more than times. This prints the values that occur more than once.

List indicates the output dataset. 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 few of them are listed below with their functionality:. Create, delete, rename, catalog, uncatalog datasets other than PDS. 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.

ON indicates the fields to be displayed on the report. Note that 1st column is occupied by the printing carriage control character. BLANK replaces all the leading zeros.

We could any of the ietool masks. Posted by cobolbasics at Numeric fields with usage COMP: Note the format tutoriaal decided as follows: Prints the tutoriwl that occur more than times. Used to return control to user and terminate. Also note that both the titles are printed. Used to copy selected parts of a JCL. See the Use of Edit patterns. Only the header and trailer kept in place and rest of tutotial data is sorted. Raj kumar Bhakthavachalam 4 September at This displays the count of records having field 36,2,ZD greater than TLEFT to print the title left justified.


Ashwani Sharma 24 November at It gives best utilization of system resources and efficient operation in bit and bit address spaces. Numeric fields with usage COMP 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.

We can turn off that display using NOCC. Also note that in the above figure the title is being printed every page.

This will copy records from 1 to 99 and then the last record.