If. 1st set of data needs to be sorted in order to merge successfully. ICETOOL MANUAL PDF - metek.me Printing tailored reports. Look at the SELECT operator, which has LAST, which should give you what you want. Icetool - Share and Discover Knowledge on SlideShare We can get the unmatched records of two files by using ICETOOL - SELECT operator; As below: //STEP01 EXEC PGM=ICETTOL //INDD1 DD DSN=KUMAR.INPUT.FILE1,DISP=SHR . SORT FIELDS=(106,4,A,1 . Common format codes for control fields. The following example shows the JCL and control statements for a simple ICETOOL job. By Using IDCAMS utility we can check whether the file is empty or not. Multiple output is handled using a single pass over the input. Removing the duplicate records from the file. Video. SUM FIELDS=NONE,XSUM SUM FIELDS=NONE means it will eliminate duplicates XSUM options will copy all records eliminated in sort process will copy to another data set defined in SORTXSUM step TAGS : SORT JCL, SORT JCL TO COPY DUPLICATES INTO ANOTHER FILE, SORT JCL SUM FIELDS XSUM OPTION. JCL ICETOOL - SlideShare DFSORT enhanced functions: December 2008 ICETOOL has an option RESIZE which is helpful when we want to create large record (single row) by combining multiple rows. ICETOOL SELECT Operator (for Experienced) Running Total has a One Tool Example. Select MAX value from multiple fields in a record using SORT - DFSORT ... Application Programming Guidecontains a sample ICETOOL job that shows how ICETOOL can be used to perform complex tasks using multiple operations and data sets in a single step, along with a complete explanation of the job. Subject: Re: How to merge two differents files with ICETOOL >>Sent this morning but hasn't made it to the list, so resending (please ignore if already posted).