Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Multiple input mapping to multiple output using SYNCSORT

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Nagendran

New User


Joined: 24 Jan 2007
Posts: 89
Location: USA

PostPosted: Thu Dec 18, 2008 6:23 pm    Post subject: Multiple input mapping to multiple output using SYNCSORT
Reply with quote

I have a set of input files which needs to be sorted and mapped to the corresponding output files.

eg: TEST.file1.in should be sorted in to output file TEST.file1.out
TEST.file2.in should be sorted in to output file TEST.file2.out

respectively.The sort condition is same for all.

Can this be done using one step or should I use different sort steps ?
Back to top
View user's profile Send private message

Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2238
Location: @my desk

PostPosted: Thu Dec 18, 2008 6:50 pm    Post subject:
Reply with quote

Nagendran,

It can be done in a single SYNCTOOL step like this.
Code:

//STEP1    EXEC PGM=SYNCTOOL         
//TOOLMSG  DD SYSOUT=*               
//DFSMSG   DD SYSOUT=*               
//IN1      DD DSN= Input file-1     
//IN2      DD DSN= Input file-2     
....                                 
....                                 
//INn      DD DSN= Input file-n
//*     
//OUT1     DD DSN= Output file-1     
//OUT2     DD DSN= Output file-2     
....                                 
....                                 
//OUTn     DD DSN= Output file-n     
//TOOLIN   DD *                     
  SORT FROM(IN1) TO(OUT1) USING(CTL1)
  SORT FROM(IN2) TO(OUT2) USING(CTL1)
....                                 
....                                 
  SORT FROM(INn) TO(OUTn) USING(CTL1)
//CTL1CNTL DD *                     
  SORT FIELDS=(p,l,f,A)
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Fri Dec 19, 2008 4:26 am    Post subject:
Reply with quote

Hi,

personally I don't see the advantage of creating a single step job to achieve the above, in the event of a failure in the second sort, you may lose the time it took to complete the first sort.

If one of the files needs to be recreated, you would have to hack the step, also unnecessary allocation of resources until required.


Gerry
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Unable to catalog a gdg dataset resid... Shovan JCL & VSAM 7 Fri Mar 24, 2017 2:24 pm
No new posts Problem reading GTF trace output danik56 ABENDS & Debugging 7 Thu Mar 16, 2017 1:02 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts To display values of multiple rows in... vinu78 DB2 2 Thu Mar 09, 2017 1:20 pm
No new posts How to get current date -1 and curren... murali.andaluri DFSORT/ICETOOL 3 Wed Mar 08, 2017 2:09 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us