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: Zologrel Shataxe
Country: Bolivia
Language: English (Spanish)
Genre: Art
Published (Last): 7 November 2013
Pages: 174
PDF File Size: 5.43 Mb
ePub File Size: 11.28 Mb
ISBN: 571-1-47258-223-4
Downloads: 71890
Price: Free* [*Free Regsitration Required]
Uploader: Saran

Also note that in the above figure the title is being printed every page.

Note the format is decided as follows: Note that only the column we mentioned in ON is printed in the report. A few of them are listed below with their functionality:.

We can specify NOCC to override default of printing carriage control characters. A File can be split into n files based on a specified condition. That is the values that appear only once.

This prints the values that occur more than once. See the Use of Edit patterns. Only the header and trailer kept in place and rest of the data is sorted. TEXT is used to decide the text to be written before the count. Numeric fields with usage COMP We could any of the existing masks.


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. The ones that occur only 1 time are not printed. Thanx a lot Wolfgang.

This displays the count of records having field 36,2,ZD greater than Matthew McKenzie 8 August at Above means keep the records from input file from record numbers to The string within is also printed before the value is printed.

All unique records will be copied to another datasets.

Using the ICETOOL utility

Above tutoeial the unique values in the column 5,8,ZD. This will copy records from 1 to 99 and then the last record. In the ON clause we can specify the format in which data will be displayed. BLANK replaces all the leading zeros. It is usually used to create empty dataset or delete an existing dataset.

icetool: ICETOOL examples

We can turn off that display using NOCC. Posted by cobolbasics at Following can be used to remove duplicates from a file and save it to another file.


List indicates the output dataset. It gives best utilization of system resources and efficient operation in bit and bit address spaces.

Ashwani Sharma 24 November at Used to copy selected parts of a JCL. Note that 1st column is occupied by the printing carriage control character. ON indicates the column for which unique must be found. TLEFT to print the title left justified.

Prints the values that occur more than times. Raj kumar Bhakthavachalam 4 September at Used to return control to user and terminate. These utility programs need to be used with appropriate DD statements in a JCL in order to achieve the specified functionality. 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.

Below prints the values that occur more than times. ON indicates the fields to be displayed on the report. This giving us a sample records for testing.