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
 

 

SYNCSORT Merge

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

New User


Joined: 18 Sep 2008
Posts: 17
Location: bangalore

PostPosted: Mon Jan 19, 2009 4:23 pm    Post subject: SYNCSORT Merge
Reply with quote

this is my JCL-merge code.here DS1 & DS2's records i want to merge in DS3, after creating this.but this code is not working.why? can anybody tell me?

Code:
                               
//STEP1 EXEC PGM=SORT                                                   
//SYSOUT  DD SYSOUT=*                                                   
//SORTIN01  DD DSN=JOP3I0.JCLTEST.DS1,DISP=SHR                           
//SORTIN02  DD DSN=JOP3I0.JCLTEST.DS2,DISP=SHR                           
//SORTOUT DD DSN=JOP3I0.JCLTEST.DS3,                                   
//           DISP=(MOD,CATLG,DELETE),                                   
//           SPACE=(CYL,(10,10),RLSE)                                   
//SYSIN DD *                                                           
  OPTION MERGE                                                         
/*
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Mon Jan 19, 2009 4:27 pm    Post subject:
Reply with quote

You also need to post the output
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Mon Jan 19, 2009 4:28 pm    Post subject:
Reply with quote

Hello Joyeetha,

Please refer to sort manual. You need to provide some thing like...

MERGE FIELDS=(110,10,CH,A,162,4,BI,D)
Back to top
View user's profile Send private message
Arun Raj

Moderator


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

PostPosted: Mon Jan 19, 2009 6:34 pm    Post subject:
Reply with quote

JOYEETA PAUL,

Input files to a MERGE operation must be presorted on a particular key and you need to mention the position,length and format of the key fields in the MERGE control statement as follows:
Code:
MERGE FIELDS=(p1,l1,f1,p2,l2,f2,....)


The violation of the above rule results in SyncSort termiating with WER068A- error
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 To Merge mutliple records into a sing... anandgbe DFSORT/ICETOOL 6 Wed Feb 22, 2017 8:49 am
No new posts SYNCSORT SEQNUM and FI fields. nartcr SYNCSORT 7 Sat Jan 21, 2017 4:02 am
No new posts Syncsort Help to group fields sudhakarraju SYNCSORT 6 Thu Dec 29, 2016 1:38 am
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am
No new posts Syncsort - Hard coded Value in output PORYES SYNCSORT 1 Thu Nov 03, 2016 9:23 am


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