Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 2296
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 Regarding the EBCDIC CCSID mapping. sakthikumarT DB2 2 Wed Jan 10, 2018 4:45 pm
No new posts Sum the fields in particular format f... sharana64 DFSORT/ICETOOL 9 Fri Jan 05, 2018 1:11 am
No new posts Preserve order in Input File pshongal DFSORT/ICETOOL 13 Thu Dec 21, 2017 4:20 pm
No new posts Merging 2 records at multiple rows wi... Bijesh DFSORT/ICETOOL 2 Wed Dec 06, 2017 1:50 am
No new posts VBS and VB, COBOL syntax is the same ... natt.sut COBOL Programming 3 Sun Nov 12, 2017 6:36 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us