Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
Help needed regarding one JCL sort

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
Author Message
shreyashighosh

New User


Joined: 02 Dec 2005
Posts: 5
Location: India

PostPosted: Fri Dec 02, 2005 2:09 pm    Post subject: Help needed regarding one JCL sort
Reply with quote

Input file1:

Code:

Zip             State              Abbreviated
Cd              Cd                 City name
_____           _______            __________

103             9                  JP
126             22                 AD
126             30                 AD
249             1                  ND
313             17                 NP


Input File2:

Code:

Zip Cd          State Cd                City name
_____           _______                 _________

103             9                       Jaipur
126             22                      Allahabad
126             30                      Ahmedabad
249             1                       New Delhi
313             17                      Nagpur


Required output file:

Code:

Zip     State     City             Abbreviated
Cd      Cd        Name             City Name
_____   _______   _________        __________

103     9         Jaipur           JP
126     22        Allahabad        AD
126     30        Ahmedabad        AD
249     1         New Delhi        ND
313     17        Nagpur           NP
Back to top
View user's profile Send private message
References
priyesh.agrawal

Global Moderator


Joined: 28 Mar 2005
Posts: 1509
Location: Chicago, IL

PostPosted: Fri Dec 02, 2005 4:08 pm    Post subject: Re: Help needed regarding one JCL sort
Reply with quote

http://www.ibm.com/servers/storage/support/software/sort/mvs/tricks/srtmst02.html#t3a

Regards,

Priyesh.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 4621
Location: San Jose, CA

PostPosted: Fri Dec 02, 2005 9:59 pm    Post subject:
Reply with quote

You can use a DFSORT/ICETOOL job like this to do what you asked for:

Code:

//S1    EXEC  PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//CON DD *    input file1
103             9                  JP
126             22                 AD
126             30                 AD
249             1                  ND
313             17                 NP
//    DD *    input file2
103             9                       Jaipur
126             22                      Allahabad
126             30                      Ahmedabad
249             1                       New Delhi
313             17                      Nagpur
/*
//OUT DD SYSOUT=*
//TOOLIN DD *
SPLICE FROM(CON) TO(OUT) ON(1,5,CH) ON(17,7,CH) -
  WITH(41,9) USING(CTL1)
/*
//CTL1CNTL DD *
  OUTFIL FNAMES=OUT,
    OUTREC=(1,5,9:17,7,19:41,9,36:36,2)
/*
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1