//DFSMSG DD SYSOUT=* –> This is where the DFSORT messages go. //TOOLIN DD * –> This is where the ICETOOL. Generating Sample data. • Basic ICETOOL JCL. • ICETOOL Utility Operators. • ICETOOL Operator Syntax. • Cool Things you can do with. You can use multiple OUTFIL statements with DFSORT or ICETOOL to write two files based on two different conditions. Here are examples with.

Author: Kagarn Kazragar
Country: Algeria
Language: English (Spanish)
Genre: Finance
Published (Last): 6 May 2013
Pages: 370
PDF File Size: 3.73 Mb
ePub File Size: 11.86 Mb
ISBN: 171-1-31926-962-8
Downloads: 43032
Price: Free* [*Free Regsitration Required]
Uploader: Mooguzuru

Sat Aug 20, 3: ON indicates the fields to be displayed on the report. Above shows the unique values in the column 5,8,ZD. If you think I should open new post.

Please make a use of Code tags. Thanx a lot Wolfgang.

That is the values that appear only once. The ones that occur only 1 time are not printed.


Complete ICETOOL examples

Note the format is decided as follows: I wrote it with respect to the code which Magesh suggested since I did not refresh the page. The string within is also printed before the value is printed. Tue Aug 23, 1: Tue Aug 23, Icetool or Joinkeys example to compare two files. Note that 1st column is occupied by the printing carriage control character.

Fri Aug 26, 1: Is for formatting purpose. Matthew McKenzie 8 August at TEXT is used to decide the text to be written before the count. We could any of the existing masks.

ICETOOL to copy files

Raj kumar Bhakthavachalam 4 September at Prints the values that occur more than times. Mon Aug 22, ezamples Only the header and trailer kept in place and rest of the data is sorted.

This giving us a sample records for testing. Also note that in the above figure the title is being printed every page.


icetool: ICETOOL examples

If you get in icetpol habit of keeping things simple, good use of resources often comes with it. This displays the count of records having field 36,2,ZD greater than Mon Aug 22, Thanks a lot for your help.

Below prints the values that occur more than times.

In the ON clause we can specify the format in which data will be displayed. Tue Aug 30, 4: See the Use of Edit patterns.

List indicates the output dataset. I thought since its an additional request, I should add it here. Fri Aug 26, 2: We can specify NOCC to override default of printing carriage control characters. Tue Aug 23, 2: Rohit Umarjikar Senior Member Joined: