//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: Mura Gorisar
Country: Bhutan
Language: English (Spanish)
Genre: Finance
Published (Last): 21 March 2004
Pages: 177
PDF File Size: 11.37 Mb
ePub File Size: 5.39 Mb
ISBN: 378-7-36712-888-8
Downloads: 33405
Price: Free* [*Free Regsitration Required]
Uploader: Akizragore

Also note that in the above figure the title is being printed exapmles page. This prints the values that occur more than once. Fri Aug 26, 2: Prints the number of records with value greater than Note that only the column we mentioned in ON is printed in the report.

Note that 1st column is occupied by the printing carriage control character.


We can specify NOCC to override default of printing carriage control characters. Prints the values that occur more than times. Is for formatting purpose. Exa,ples kumar Bhakthavachalam 4 September at Icetool or Joinkeys example to compare two files. Also note that both the titles are printed.

  DIN VDE 0833-2 PDF

I can certainly modify the include in the code which you suggested. Rohit, by the time I wrote icetool new requirement, I had not seen the code you pasted.

ICETOOL example

The ones that occur only 1 time are not printed. Tue Aug 23, 2: Sat Aug 20, 3: That is the values that appear only once. Mon Aug 29, 9: Note the format is decided as follows: Ashwani Sharma 24 November at We can turn off that display using NOCC.

This will copy icetkol from 1 to 99 and then the last record. Tue Aug 23, 1: Sat Aug 20, 2: Thanks a lot for your jcetool. This giving us a sample records for testing. Fri Aug 26, 1: TEXT is used to decide the text to be written before the count. Need help on the multiple files refor I have a requirement where I need 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.


I can do that. Please make a use of Code tags. Matthew McKenzie 8 August at I wrote it with exxmples to the code which Magesh suggested since I did not refresh the page.


They want this functionality to work only when month from file 2 is “12” in both the dates. If you think I should open new post. List indicates the output dataset.

ICETOOL example

Anyone know how to copy Unix files? We can discuss on choices as we want but for your point, I don’t disagree. If you get in the habit of keeping things simple, good use of resources often comes with it.

The string within is also printed before the value is printed. Numeric fields with usage COMP: Above means keep the records from input file from record numbers to See the Use of Edit patterns. Tue Ietool 30, 4: Following can be used to remove duplicates from a file and save it to another file.

This displays the count of records having field 36,2,ZD greater than Sat Aug 20, 4: Below prints the values that occur more than times.