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: Nasar Tulmaran
Country: Canada
Language: English (Spanish)
Genre: Life
Published (Last): 6 February 2010
Pages: 241
PDF File Size: 1.76 Mb
ePub File Size: 12.46 Mb
ISBN: 806-6-79823-285-9
Downloads: 75765
Price: Free* [*Free Regsitration Required]
Uploader: Gusida

Note that tuforial the column we mentioned in ON is printed in the report. The ones that occur only 1 time are not printed. 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. It is usually used to create empty dataset or delete an existing dataset. All unique records will be copied to another datasets. Above means keep the records from input file from record numbers to Used to copy selected parts of a JCL.

Used to return control to user and terminate. Tutoeial Sharma 24 November at A few icetol them are listed below with their functionality:. Following can be used to remove duplicates from a file and save it to another file.

That is the values that appear only once. Matthew McKenzie 8 August at 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. Also note that in the above figure the title is being printed every page. Also note that both the titles are printed.


A File can be split into n files based on a specified condition. 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.

These utility programs need to be used with appropriate DD statements in a JCL in tuyorial to achieve the specified functionality. This displays the count of records having field 36,2,ZD greater than The string within is also printed before the value is printed.

Is for formatting purpose. We could any of the existing masks.

ICETOOL Tutorial

Raj kumar Bhakthavachalam 4 September at In the ON clause we can specify the format in which data will be displayed. We can turn off that display using NOCC. Posted by cobolbasics at It gives best utilization of system resources and efficient operation in bit and bit address spaces. Create, delete, rename, catalog, uncatalog datasets other than PDS. See the Use of Edit patterns. This will copy records from 1 to 99 and then the last record.

Note that 1st column is occupied by the printing carriage control character. Numeric fields with usage COMP: Frequently used sort tricks using these utilities are explained in the next chapter.


We can specify NOCC to tutrial default of printing carriage control characters. TLEFT to print the title left justified. Numeric fields with usage COMP This giving us a sample records for testing.

Complete ICETOOL examples

Note the format is decided as follows: ON indicates the column for which unique must be found. Usually used to manage VSAM datasets. This prints the values that occur more than once. Input and output datasets can be defined using tutogial defined DD names. Only the header and trailer kept in place and rest of the data is sorted.

icetool: ICETOOL examples

Prints the values that occur more than times. Prints the number of records with icetoool greater than TEXT is used to decide the text to be written before the count. List indicates the output dataset. ON indicates the fields to be displayed on the report. Above shows the unique values in the column 5,8,ZD.

Below prints the values that occur more than times. Thanx a lot Wolfgang. Usually, this is not recommended in view of performance for large files.