DFSORT/ICETOOL: Hi All, I have two VSAM Files as Input, When I am trying to SORT with ‘PGM=SORT’ & ‘PGM=ICETOOL’, I am getting a. But i see the LOG and i Note that ICETOOL, use however the input file two times. i beleived that ICETOOL use the input-file one time to write two. 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.

Author: Dogal Akinosida
Country: Azerbaijan
Language: English (Spanish)
Genre: Life
Published (Last): 9 May 2008
Pages: 60
PDF File Size: 18.90 Mb
ePub File Size: 16.76 Mb
ISBN: 719-4-55447-820-2
Downloads: 94024
Price: Free* [*Free Regsitration Required]
Uploader: Akizahn

Thanx a lot Wolfgang. TEXT is used to decide the text to be written before the count.

Only the header and trailer kept in place mainnframe rest of the data is sorted. List indicates the output dataset. ON indicates the fields to be displayed on the report.

Complete ICETOOL examples

Note that 1st column is occupied by the printing carriage control character. We can turn off that display using NOCC.


Note that only the column we mentioned in ON is printed in the report. Also note that both the titles are printed. Is for formatting purpose.

The Big Old Mainframe: ICETOOL Example – Matching and non matching records

Also note that in the above figure the title is being printed every page. TLEFT to print the title left justified.

We can specify NOCC to override default of printing carriage control characters. The string within is also printed before the value is printed. ON indicates the column for which unique must be found. Above shows the unique values in the column 5,8,ZD. BLANK replaces all the leading zeros.

That is the values that appear only once. This prints the values that occur more than once.

The ones that occur only 1 time are not printed. Below prints the values that occur more than times. Prints the values that occur more than times. In the ON clause we can specify the format in which data will be displayed. We could any of the existing masks. Note the format is decided as follows: Numeric fields with usage COMP: Numeric fields with usage COMP See the Use of Edit patterns.


JCL Utility Programs

This displays the count of records having field 36,2,ZD greater than Prints the number of records with value greater than Following can be used to remove duplicates from a file and save it to another file.

All unique records will be copied to another datasets.

Above means keep the records from input file from record numbers to This will copy records from 1 mqinframe 99 and then the last record. This giving us a sample records for testing. Posted by cobolbasics at Raj kumar Bhakthavachalam 4 September at Ashwani Sharma 24 November at Matthew McKenzie 8 August at