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: Dalkis Dishura
Country: Mauritius
Language: English (Spanish)
Genre: Finance
Published (Last): 16 February 2005
Pages: 431
PDF File Size: 14.17 Mb
ePub File Size: 6.13 Mb
ISBN: 421-3-37186-952-6
Downloads: 39439
Price: Free* [*Free Regsitration Required]
Uploader: Bragar

List indicates the output dataset. Above shows the unique values in the column 5,8,ZD. This giving us a sample records for testing. The ones that occur only 1 time are not printed. Icetpol gives best utilization of system resources and efficient operation in bit and bit address spaces. We could any of the existing masks. ON indicates the fields to be displayed on the report.

Also note that in the above figure the title is being printed every page. Usually used to manage VSAM datasets. Also note that both the titles are printed.

Used to copy selected parts of a JCL.

The string within is also printed before the value is printed. Matthew McKenzie 8 August at Only the header and trailer iceetool in place and rest of the data is sorted. Used to return control to user and terminate.


Posted by cobolbasics at Note the format is decided as follows: Following can be used to remove duplicates from a file and save it to another file.

Using the ICETOOL utility

This will copy records from 1 to utilitt and then the last record. Numeric fields with usage COMP 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, this is not recommended in view of performance for large files.

BLANK replaces all the leading zeros. All unique records will be copied to another datasets. A few of them are listed below with their functionality:. Input and output datasets can be defined using user defined DD names.

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. This prints the values that occur more than once.

Create, delete, rename, catalog, uncatalog datasets other than PDS. Raj kumar Bhakthavachalam 4 September at ON indicates the column for which unique must be found. See the Use of Edit patterns.

Complete ICETOOL examples

A File can be split into n files based on a specified condition. In the Ixetool clause we can specify the format in which data will be displayed. 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 We can specify NOCC to override default of printing carriage control characters. Utilityy to print the title left justified. It is usually used to create empty dataset or delete an existing dataset. Is for formatting purpose. We icetoop turn off that display using NOCC. Frequently used sort tricks using these utilities are explained in the next chapter.


Thanx a lot Wolfgang. Numeric fields with usage COMP: Below prints the values that occur more than times.

Prints the number of records with value greater than That uti,ity the values that appear only once. 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. Prints the values that occur more than times. TEXT is used to uility the text to be written before the count. Ashwani Sharma 24 November at This displays the count of records having field 36,2,ZD greater than Note that 1st column is occupied by the printing carriage control character.

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