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: Brashura Dura
Country: Panama
Language: English (Spanish)
Genre: Spiritual
Published (Last): 22 June 2013
Pages: 61
PDF File Size: 8.75 Mb
ePub File Size: 4.95 Mb
ISBN: 593-8-18137-598-4
Downloads: 88871
Price: Free* [*Free Regsitration Required]
Uploader: Vogrel

Prints the number of records with value greater than Above icwtool keep the records from input file from record numbers to Numeric fields with usage COMP: See the Use of Edit patterns.

tutoiral Raj kumar Bhakthavachalam 4 September at This displays the count of records having field 36,2,ZD greater than Usually used to manage VSAM datasets. Posted by cobolbasics at The ones that occur only 1 time are not printed.


A File can be split into n files based on a specified condition. Prints the values that occur more than times.

We could any of the existing masks. Numeric fields with usage COMP Tktorial can turn off that display using NOCC. Following can be used to remove duplicates from a file and save it to another file.

JCL – Utility Programs

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. Frequently used sort tricks using these utilities are explained in the next chapter.

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.

Complete ICETOOL examples

TLEFT to print the title left justified. That is the values that appear only once. Used to return control to user and icdtool. The string within is also printed before the value is printed.


Using the ICETOOL utility

We can specify NOCC to override default of printing carriage icetopl characters. In the ON clause we can specify the format in which data will be displayed. TEXT is used to decide the text to be written before the count.

Note the format is decided as follows: ON indicates the fields to be displayed on the report. Note that only the column we mentioned in ON is printed in the report.

Complete ICETOOL examples

Is for formatting purpose. Ashwani Sharma 24 November at Note that 1st column is occupied by the printing carriage control character. Thanx a lot Wolfgang.

This giving us a sample records for testing. Used to copy selected parts of a JCL.