//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: Felkis Vudoshakar
Country: Lesotho
Language: English (Spanish)
Genre: Environment
Published (Last): 25 September 2015
Pages: 175
PDF File Size: 17.99 Mb
ePub File Size: 3.8 Mb
ISBN: 622-9-59584-749-2
Downloads: 11168
Price: Free* [*Free Regsitration Required]
Uploader: Zululkree

In the ON clause we can specify the format in which data will be displayed.

Also note that in the above figure the title is being printed every page. Note that 1st column is occupied by the printing carriage control character. Posted by cobolbasics at Examplew Aug 20, 2: Is for formatting purpose.


Need help on the multiple files refor Also note that both the titles are printed. Icetool or Joinkeys example to compare two files.


This prints the values that occur more than once. Tue Aug 23, Rohit Umarjikar Senior Member Joined: Numeric fields with usage COMP: Below prints the values that occur more than times.

They want this functionality to work only when month from file 2 is “12” in both the dates. All unique records will be copied to examplles datasets.

Sat Aug 20, 4: Above means keep the records from input file from record numbers to Numeric fields with usage COMP The string within is also printed before the value is printed.

Please make a use of Code tags.


I can do that. See the Use of Edit patterns. If you think I should open new post. Prints the number of records with value greater than I eexamples certainly modify the include in the code which you suggested.


I have a requirement where I exampless to remove records from one file based on two dates which are present in other file. I thought since its an additional request, I should add it here. This will copy records from 1 to 99 and then the last record. Note that only the column we mentioned in ON is printed in the report.

IBM MAINFRAME: Icetool or Joinkeys example to compare two files

Ashwani Sharma 24 November at Mon Aug 29, 9: I wrote it exam;les respect to the code which Magesh suggested since I did not refresh the page. List indicates the output dataset.

We could any of the existing masks.

Author: admin