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: Kigrel Jugrel
Country: Mayotte
Language: English (Spanish)
Genre: Literature
Published (Last): 19 June 2010
Pages: 346
PDF File Size: 15.46 Mb
ePub File Size: 19.57 Mb
ISBN: 206-1-90075-432-6
Downloads: 45926
Price: Free* [*Free Regsitration Required]
Uploader: Dairisar

Posted by cobolbasics at Raj kumar Bhakthavachalam 4 September at Above means keep the records from input file from record numbers to The ones that occur only 1 time are not printed. It is usually used to create empty dataset or delete an existing dataset.

These utility programs need to be used with appropriate DD statements in a JCL in order to achieve the specified functionality. Usually, this is not recommended in view of performance utilty large files.

ON indicates the fields to be displayed on the report.

Complete ICETOOL examples

Usually used to manage VSAM datasets. Also note that in the above figure the title is being printed every page. This displays the count of records having field 36,2,ZD greater than Ashwani Sharma 24 November at ON indicates the column for which unique must be found.


Input and output datasets can be defined using user defined DD names. This prints the values that occur more than once. Note that 1st column is occupied by the printing carriage control character. Numeric fields with usage COMP Also note utilityy both the titles are printed.

All unique records will be copied to another datasets.

Complete ICETOOL examples

utilitty Following can be used to remove duplicates from a file and save it to another file. This giving us a sample records for testing.

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.

TLEFT to print itility title left justified. Above shows the unique values in the column 5,8,ZD. Frequently used sort tricks using these utilities are explained in the next chapter. Create, delete, rename, catalog, uncatalog datasets other than PDS. Is for formatting purpose.

Only the header and trailer kept in place and rest of the data is sorted. We could any of the existing masks. A File can be split into n files based on a specified condition. Note the format is decided as follows: 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.


Thanx a lot Wolfgang. Numeric fields with usage COMP: We can turn off that display using NOCC. Prints the values that occur more than times.

A few of them are listed below with their functionality:. See the Use of Edit patterns. This will copy records from 1 to 99 and then the last record.

That is the values that appear only once. Note that utilith the column we mentioned in ON is printed in the report. 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.