Hi,I got a scenario to write a jcl to sort the two files and write the matched and unmatched records into 2 different files using ICETOOL utility. DFSORT/ICETOOL: Hi all I want to know what exactly is ICETOOL utility & what is its function and usage:?:?. JCL Utility Programs – Learn JCL (Job Control Language) in simple and easy steps DFSORT is a powerful IBM utility used to copy, sort or merge datasets.

Author: Taugore Sazuru
Country: Egypt
Language: English (Spanish)
Genre: Literature
Published (Last): 10 November 2016
Pages: 199
PDF File Size: 16.85 Mb
ePub File Size: 1.95 Mb
ISBN: 889-6-99212-561-9
Downloads: 59152
Price: Free* [*Free Regsitration Required]
Uploader: Samurisar

This displays the count of records having field 36,2,ZD greater than A few of them are listed below with their functionality:. Above means keep the records from input file from record numbers to Create, delete, rename, catalog, uncatalog datasets other than PDS.

JCL Utility Programs

Prints the number of records with value greater than A File can be split into n files based on a specified condition. Note that 1st column is occupied by the printing carriage control character. This giving us a sample records icetool testing. Below prints the values that occur more than times. This will copy records from 1 to 99 and then the last record. It gives best utilization of system resources and efficient operation in bit and bit address spaces.

In the ON clause we can specify the format in which data will be displayed.


Complete ICETOOL examples

Prints the values that occur more than times. Only the header and trailer kept in place and rest of the data is sorted. Also note that both the titles are printed. TEXT is used to decide the text to be written before the count. See the Use of Edit patterns.

This prints the values that occur more than once. 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. Used to return control to user and terminate. It can compare two or icetooo files on specified field s and create one or more output files like file with matching records, file with non-matching records, etc.

All unique records will be copied to another datasets. List indicates the output dataset. ON indicates the column for which unique must be found.

Using the ICETOOL utility

Thanx a lot Wolfgang. 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. Matthew McKenzie 8 August at Note that only the column we mentioned in ON is printed in the report.

Following can be used to remove duplicates from a file and save utlity to another file. Usually, this is not recommended in view of performance for large files.

That is the values that appear only once. Posted by cobolbasics at The ones that occur only 1 time are not printed. These utility programs need to be used with appropriate DD statements in a JCL in order to achieve the specified functionality.


Raj kumar Bhakthavachalam 4 September at Input and output datasets can be defined using user defined DD names. Ashwani Sharma 24 November at Numeric fields with usage COMP Htility to print the title left justified.

IBM MAINFRAME: What exactly is ICETOOL utility & its usage

We can specify NOCC to override default of printing carriage control characters. ON indicates the fields to be displayed on the report. Is for formatting purpose. BLANK replaces all the leading zeros. Numeric fields with usage COMP: We can turn off that display using NOCC. We could any of the existing masks. Usually used to manage VSAM datasets. Frequently used sort tricks using these utilities are explained in the next chapter.

The string within is also printed before the value is printed.

Note the format is decided as follows: Used to copy selected parts of a JCL. Also note that in the above figure the title is being printed every page. Above shows the unique values in the utiluty 5,8,ZD. It is usually used to create empty dataset or delete an existing dataset.