//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: Gur Kigalkis
Country: Libya
Language: English (Spanish)
Genre: History
Published (Last): 12 February 2014
Pages: 220
PDF File Size: 20.78 Mb
ePub File Size: 9.25 Mb
ISBN: 763-7-29679-462-5
Downloads: 88455
Price: Free* [*Free Regsitration Required]
Uploader: Jucage

The string within is also printed before the value is printed. Thanks a lot for your help. We can specify NOCC to override default of printing carriage control characters.

ICETOOL example

Following can be used to remove duplicates from a file and save it to another file. In the ON clause we can specify the format in which data will be displayed.

Fri Aug 26, 2: This will copy records from 1 to 99 and then the last record. Above shows the unique values in the column 5,8,ZD.


We could any of the existing masks. Exxmples thought since its an additional request, I should add it here. Icetool or Joinkeys example to compare two files. We can turn off that display using NOCC.

ICETOOL to copy files

Numeric fields with usage COMP Rohit Umarjikar Senior Member Joined: Please make a use of Code tags. Tue Aug 30, 4: Below prints the values that occur more than times. Ashwani Sharma 24 November at Is for formatting purpose. If you get in the 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 Tue Aug 23, 1: See the Use of Edit patterns.

Rohit, by the time I wrote this new requirement, I had not seen the code you pasted. Prints the number of records with value greater than ON indicates the fields to be displayed on the report.

Only the header and trailer kept in place and rest of the data is sorted.

Note the format is decided as follows: Anyone know how to examplfs Unix files? I had to come back again since I have additional requirement from user. Prints the values that occur more than times. The ones that occur only 1 time are not printed.


If you are providing this as an example for joinkey, may be, but still there are plenty of examples available for Joinkeys in this forum. Numeric fields with usage COMP: I can examplfs that. Note that only the column we mentioned in ON is printed in the report.

For ocetool problem, joinkey is not at all recommended. Note that 1st column is occupied by the printing carriage control character. They want this functionality to work only when month from file 2 is “12” in both the dates.

Mon Aug 22, 7: That is the values that appear only once. Tue Aug 23,