Re:ICETOOL UTILITY



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

Re:ICETOOL UTILITY

Postby sindhu1 » Tue Sep 04, 2012 12:35 pm

Hi,

I got a scenario to write a jcl to sort the two files and write the matched and unmatched records into 2 different files using ICETOOL utility.Can anyone give the job code explaining it in detail....I am new to ICETOOL utility....
sindhu1
 
Posts: 3
Joined: Fri Aug 03, 2012 11:42 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Re:ICETOOL UTILITY

 

Re: Re:ICETOOL UTILITY

Postby enrico-sorichetti » Tue Sep 04, 2012 1:47 pm

why not search the forum Yourself, there are zillions of examples
and the most of them are explained very clearly

being new to something does not exempt you from doing a bit of work Yourself
and from asking people who spend time helping to write and post over and over the same things/suggestions/code snippets
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2706
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 139 times

Re: Re:ICETOOL UTILITY

Postby BillyBoyo » Tue Sep 04, 2012 1:56 pm

Why would it have to be ICETOOL?

Just plain SORT with JOINKEYS, assuming your program level is close to up-to-date.

Can you post the ICE201I message from the sysout of any sort step, please?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: Re:ICETOOL UTILITY

Postby NicC » Tue Sep 04, 2012 4:28 pm

Are you wanting the JCL or the control cards?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2755
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 110 times

Re: Re:ICETOOL UTILITY

Postby sindhu1 » Tue Sep 04, 2012 6:40 pm

i have been searching....but couldn't understand the syntax of MATACNTL DD * and MATBCNTL DD * MATCCNTL DD * in the code.could u please xplain?

//S1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//F1IN DD DSN=A123456.SORT.SAMPIN,DISP=SHR
//F2IN DD DSN=A123456.SORT.SAMPADD,DISP=SHR
//T1 DD DSN=&&&T1,DISP=(MOD,PASS),UNIT=SYSDA,SPACE=(CYL,(5,5),RLSE)
//MATCH DD DSN=COURSE.MATCH,DISP=(NEW,CATLG,DELETE),
//F1ONLY DD DSN=COURSE.INONLY,DISP=(NEW,CATLG,DELETE),
//F2ONLY DD DSN=COURSE.ADDONLY,DISP=(NEW,CATLG,DELETE),
//TOOLIN DD *
COPY FROM(F1IN) TO(T1) USING(MATA)
COPY FROM(F2IN) TO(T1) USING(MATB)

SPLICE FROM(T1) TO(MATCH) ON(1,5,CH) -
WITH(32,1) KEEPNODUPS USING(MATC)
/*
//MATACNTL DD *
OUTREC FIELDS=(1:115,5, Course number
6:120,25, Course name
31:C'11') '11' id for File1 records
/*
//MATBCNTL DD *

OUTREC FIELDS=(1:115,5, Course number
6:120,25, Course name
31:C'22') '22' id for File2 records
/*
//MATCCNTL DD *

OUTFIL FNAMES=MATCH,INCLUDE=(31,2,CH,EQ,C'12'),OUTREC=(1,30)
OUTFIL FNAMES=F1ONLY,INCLUDE=(31,2,CH,EQ,C'11'),OUTREC=(1,30)
OUTFIL FNAMES=F2ONLY,INCLUDE=(31,2,CH,EQ,C'22'),OUTREC=(1,30)
/*
sindhu1
 
Posts: 3
Joined: Fri Aug 03, 2012 11:42 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Re:ICETOOL UTILITY

Postby BillyBoyo » Tue Sep 04, 2012 6:48 pm

OK, forget this example for the moment. Find a very simple JOINKEYS example. Try to run it. If it runs, forget the SPLICE solution. JOINKEYS supercedes SPLICE solutions for matching files.

Do that, then we can explain the "cntl" files. Please show the sysout from your step when you run the JOINKEYS so that we can see what functions/product you have available.

This this one, for instance: syncsort-synctool/compare-two-files-t8101.html#p38049
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post