IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SYNCSORT Merge


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
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
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: 8797
Location: Welsh Wales

PostPosted: Mon Jan 19, 2009 4:27 pm
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: 1208
Location: Bangalore,India

PostPosted: Mon Jan 19, 2009 4:28 pm
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: 2481
Location: @my desk

PostPosted: Mon Jan 19, 2009 6:34 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Merge two VSAM KSDS files into third ... JCL & VSAM 6
This topic is locked: you cannot edit posts or make replies. Merge 2 input files based on the reco... JCL & VSAM 2
No new posts Merge 2 input files after sort SYNCSORT 14
No new posts Merge files with a key and insert a b... DFSORT/ICETOOL 6
Search our Forums:

Back to Top