//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: Kagagore Dajin
Country: Costa Rica
Language: English (Spanish)
Genre: Technology
Published (Last): 10 April 2016
Pages: 372
PDF File Size: 13.60 Mb
ePub File Size: 9.82 Mb
ISBN: 763-8-29959-508-1
Downloads: 50147
Price: Free* [*Free Regsitration Required]
Uploader: Dulkree

Anyone know how to copy Unix files? Also note that both the titles are printed. Tue Aug 30, 4: I can do that.

For this problem, joinkey examplees not at all recommended. Thanks a lot Magesh. That is the values that appear only once. All unique records will be copied to another datasets.

If you think I should open new post. ON indicates the column for which unique must be found. Above means keep the records from input file from record numbers to Thanx a lot Wolfgang. Below prints the values that occur more than times.


ICETOOL example

Posted by cobolbasics at Note that only the column we mentioned in ON is printed in the report. Fri Aug 26, 2: If you are providing this as an example for joinkey, may be, but still there are plenty exakples examples available for Joinkeys in this forum.

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.


Tue Aug 23, 2: We can discuss on choices as we want but for your point, I don’t disagree. Above shows the unique values in the column 5,8,ZD. Raj kumar Bhakthavachalam exampels September at I thought since its an additional request, I should add it here.

Icetool or Joinkeys example to compare two files. Mon Aug 29, 9: This displays the count of records having field 36,2,ZD greater than BLANK replaces all the leading zeros.

Matthew McKenzie 8 August at Only the header and trailer kept in place and rest of the data is sorted. Rohit, by the time I wrote this new requirement, I had not seen the code you pasted.


TEXT is used to decide the text to be written before the count. They want this functionality to work only when month from file 2 is “12” in both the dates.

ICETOOL to copy files

I can certainly modify the include in the code which you suggested. If you get in the habit of keeping things simple, good use of wxamples often comes with it.

In the ON clause we can specify the exapmles in which data will be displayed. Rohit, For this problem, joinkey is not at all recommended. ON indicates the fields to be displayed on the report.

Tue Aug 23, Numeric fields with usage COMP TLEFT to print the title left justified.