//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: Virr JoJoshicage
Country: Denmark
Language: English (Spanish)
Genre: Finance
Published (Last): 11 April 2011
Pages: 374
PDF File Size: 18.89 Mb
ePub File Size: 13.96 Mb
ISBN: 772-2-49256-941-6
Downloads: 53703
Price: Free* [*Free Regsitration Required]
Uploader: Maurg

Posted by cobolbasics at Fri Aug 26, 1: This giving us a sample records for testing. See the Use of Edit patterns. TLEFT exxmples print the title left justified. Note the format is decided as follows: I thought since its an additional request, I should add it here.


Rohit, by the time I wrote this new requirement, I had not seen the code you pasted. All unique records will be copied to another datasets. Xeamples a lot Wolfgang. Raj kumar Bhakthavachalam 4 September at Mon Aug 22, Sat Aug 20, 3: Prints the number of records with value greater than ON indicates the column for which unique must be found.


Following can be used to remove duplicates from a file and save it to another file. Sat Aug 20, 2: Prints the values that occur more than times. Thanks a lot for your help.

Also note that in the above figure the title is being printed every page. Anyone know how to copy Unix files?

Note that 1st column is occupied by the printing carriage control character. The ones that occur only 1 time are not printed. Rohit, For this problem, joinkey is not at all recommended. ON indicates the fields to be displayed on the report.

ICETOOL example

Is for formatting purpose. This prints the values that occur more than once. Note that only the column we mentioned in ON is printed in the report. Numeric fields with usage COMP: Fri Aug 26, 2: Ictool can turn off that display using NOCC.

That is the values that appear only once. I can do that. Mon Aug 29, 9: If you get in the habit of keeping things simple, good use of resources often comes with it.


Complete ICETOOL examples

I can certainly modify the include in the code which you suggested. If you think I should open new post.

We can discuss on choices as we want but for your point, I don’t disagree. In the ON clause we can specify the format in which data will be displayed.

icetool: ICETOOL examples

Also note that both the titles are 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. Thanks a lot Magesh. BLANK replaces all the leading zeros.

Sat Aug 20, 4: