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: Arabei Vumi
Country: Montenegro
Language: English (Spanish)
Genre: Travel
Published (Last): 27 March 2005
Pages: 186
PDF File Size: 5.91 Mb
ePub File Size: 1.26 Mb
ISBN: 927-1-87878-987-9
Downloads: 31275
Price: Free* [*Free Regsitration Required]
Uploader: Domi

That is the values that appear only once. ON indicates the fields to be displayed on the report. Thanx a lot Wolfgang. Numeric fields with usage COMP Note that 1st column is occupied by the printing carriage control icftool.

These utility programs need to be used with appropriate DD statements in a JCL in order to achieve the specified functionality. It gives best utilization of system resources and efficient operation in bit and bit address spaces.

Ashwani Sharma 24 November at 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. This will copy records from 1 to 99 and then the last record.

Used to copy selected parts of a JCL. Only the header and trailer kept in place and rest of the data is sorted. A few of them are listed below with their functionality:. In the ON clause we can icetol the format uhility which data will be displayed. All unique records will be copied to another datasets. Following can be used to remove duplicates from a file and save it to another file.


This displays the count of records having field 36,2,ZD greater than We can specify NOCC to override default of printing carriage control characters. Posted by cobolbasics at Usually, this is not recommended in view of icetoo for large files.

We can turn off that display using NOCC. The ones that occur only 1 time are not printed. Also note that in the above figure the title is being printed every page. Is for formatting purpose.

JCL – Utility Programs

Prints the number of records with value greater than Raj kumar Bhakthavachalam 4 September at TEXT is used to decide the text to be written before the count. A File can be split into n files based on a specified condition. Frequently used sort tricks using these utilities are explained in the next chapter.

See the Use of Edit patterns. Input and output datasets can be defined using user defined DD names. Iceotol prints the values that occur more than times.

ON indicates the column for which unique must be found. Usually used to manage VSAM datasets. It is usually used to create empty dataset or delete an existing dataset. Note that only the column we mentioned in ON icetoool printed in the report.


Matthew McKenzie 8 August at Prints the values that occur more than times. Above means keep the records from input file from record numbers to 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.

This prints the values that occur more than once. Numeric fields with usage COMP: Create, delete, rename, catalog, uncatalog datasets other than PDS.

The string within is also printed before the value is printed. We could any of the existing masks.

Using the ICETOOL utility

Note the format is decided as follows: TLEFT to print the title left justified. Also note that both the titles are printed. List indicates icetol output dataset. 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.