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
 

 

Error getting for merge and split files using syncsort

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

New User


Joined: 15 Nov 2007
Posts: 29
Location: Bangalore

PostPosted: Tue Sep 28, 2010 10:17 am    Post subject: Error getting for merge and split files using syncsort
Reply with quote

my requirment is i need to merge two files to a single file, but i am geting the following error
Code:
SYNCSORT LICENSED FOR CPU SERIAL NUMBER 2F771, MODEL 2094 705             
SYSIN :                                                                   
   MERGE FIELDS=(1,3,CH,A)                                               
   SUM FIELDS=NONE,XSUM                                                   
WER276B  SYSDIAG= 575947, 1830438, 1830438, 2892600                       
WER164B  9,280K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,       
WER164B     0 BYTES RESERVE REQUESTED, 1,672K BYTES USED                 
WER146B  128K BYTES OF EMERGENCY SPACE ALLOCATED                         
WER109I  MERGE INPUT  :   TYPE=F; LRECL=    80                           
WER110I  SORTOUT  : RECFM=FB   ; LRECL=   320; BLKSIZE=  8000             
WER462I  OUTPUT LRECL DIFFERS FROM SORTOUT LRECL                         
WER410B  7,740K BYTES OF VIRTUAL STORAGE AVAILABLE ABOVE THE 16MEG LINE, 
WER410B     0 BYTES RESERVE REQUESTED, 1,420K BYTES USED                 
WER055I  INSERT          0, DELETE          0                             
WER068A  OUT OF SEQ SORTIN01 , BLOCK 1                                   
WER211B  SYNCSMF  CALLED BY SYNCSORT; RC=0000     


jcl for merge:
Code:
//SORT1    EXEC  PGM=SYNCSORT                             
//SYSOUT   DD  SYSOUT=*                                   
//SORTIN   DD DSN=LST.C42357.SORTNEW(SORTINPT),DISP=SHR   
//SORTIN01 DD DSN=LST.C42357.SORTNEW(SORTINP),DISP=SHR     
//SORTOUT  DD DSN=LST.C42357.SRTOT,DISP=SHR               
//SORTXSUM DD DSN=LST.C42357.SRTOT1,DISP=SHR               
//SYSIN    DD *                                           
   MERGE FIELDS=(1,3,CH,A)                                 
   SUM FIELDS=NONE,XSUM                                   
/*




jcl for split
Code:
//SORT1    EXEC  PGM=SYNCSORT                                           
 //SYSOUT   DD  SYSOUT=*                                                 
 //SORTIN   DD DSN=LST.C42357.SORTNEW(SORTINPT),DISP=SHR                 
 //SORTOUT1 DD DSN=LST.C42357.SORTNEW(SORTOUT),DISP=SHR                 
 //SORTOUT2 DD DSN=LST.C42357.SORTNEW(SORTOUT1),DISP=SHR                 
 //SYSIN    DD *                                                         
    SORT FIELDS=(18,4,CH,A)                                             
    OUTFIL FNAMES=SORTOUT1,OUTREC=(1,30),INCLUDE=(23,5,CH,EQ,C'BTECH')   
    OUTFIL FNAMES=SORTOUT2,OUTREC=(1,30),OMIT=(23,5,CH,EQ,C'BTECH')     
 /*



Please help me to solve it.
Back to top
View user's profile Send private message

prahalad

New User


Joined: 14 Sep 2010
Posts: 18
Location: Pune

PostPosted: Tue Sep 28, 2010 10:28 am    Post subject:
Reply with quote

The output file LRECL mismatch with SORTOUT LRECL. Please try with correct LRECL

OUTPUT LRECL DIFFERS FROM SORTOUT LRECL
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Tue Sep 28, 2010 11:02 am    Post subject:
Reply with quote

Hi,

I would be concerned about

Code:
WER068A  OUT OF SEQ SORTIN01 , BLOCK 1 


Are the input files in the correct sequence. ?



Gerry
Back to top
View user's profile Send private message
royalchm

New User


Joined: 15 Nov 2007
Posts: 29
Location: Bangalore

PostPosted: Tue Sep 28, 2010 11:26 am    Post subject:
Reply with quote

i have tried with LRECl=80,, then also it's giving the same error.
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Tue Sep 28, 2010 11:37 am    Post subject:
Reply with quote

Hi,

just so you understand my question, are the input datasets already sorted ?


Gerry
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Sep 28, 2010 9:43 pm    Post subject:
Reply with quote

Hello,

Quote:
i have tried with LRECl=80,, then also it's giving the same error.
You should not try "this and that". You should submit jcl and control statements that are consistent with the file attributes.

As Gerry mentioned - you also need to have the files in sequence to do a merge. . .
Back to top
View user's profile Send private message
royalchm

New User


Joined: 15 Nov 2007
Posts: 29
Location: Bangalore

PostPosted: Wed Sep 29, 2010 10:25 am    Post subject:
Reply with quote

Thanks gerry for the help, it's working fine. Actually my input was not in sorted order.
Thanks agian icon_smile.gif icon_surprised.gif
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Sep 29, 2010 7:13 pm    Post subject: Reply to: Error getting for merge and split files using sync
Reply with quote

Good to hear it is working - thank you for letting us know icon_smile.gif

Quote:
Actually my input was not in sorted order.
Which will "kill" a merge every time icon_wink.gif

d
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 create multiple files using... mbattu COBOL Programming 3 Fri May 05, 2017 5:35 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
This topic is locked: you cannot edit posts or make replies. Merge two files and update Trailer re... Yashashri JCL & VSAM 1 Thu May 04, 2017 12:54 pm
No new posts Dynamic split of files under groups sril.krishy DFSORT/ICETOOL 4 Mon Apr 17, 2017 1:09 pm
No new posts Compare two files and subtract values ameetmund DFSORT/ICETOOL 7 Fri Mar 31, 2017 3:35 pm


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