View previous topic :: View next topic
|
Author |
Message |
royalchm
New User
Joined: 15 Nov 2007 Posts: 29 Location: Bangalore
|
|
|
|
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 |
|
|
prahalad
New User
Joined: 14 Sep 2010 Posts: 18 Location: Pune
|
|
|
|
The output file LRECL mismatch with SORTOUT LRECL. Please try with correct LRECL
OUTPUT LRECL DIFFERS FROM SORTOUT LRECL
|
|
Back to top |
|
|
gcicchet
Senior Member
Joined: 28 Jul 2006 Posts: 1702 Location: Australia
|
|
|
|
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 |
|
|
royalchm
New User
Joined: 15 Nov 2007 Posts: 29 Location: Bangalore
|
|
|
|
i have tried with LRECl=80,, then also it's giving the same error. |
|
Back to top |
|
|
gcicchet
Senior Member
Joined: 28 Jul 2006 Posts: 1702 Location: Australia
|
|
|
|
Hi,
just so you understand my question, are the input datasets already sorted ?
Gerry |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
royalchm
New User
Joined: 15 Nov 2007 Posts: 29 Location: Bangalore
|
|
|
|
Thanks gerry for the help, it's working fine. Actually my input was not in sorted order.
Thanks agian |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Good to hear it is working - thank you for letting us know
Quote: |
Actually my input was not in sorted order. |
Which will "kill" a merge every time
d |
|
Back to top |
|
|
|
|