********************************* TOP OF DATA **********************************
SYNCSORT FOR Z/OS 1.4.0.1R U.S. PATENTS: 4210961, 5117495 (C) 2010 SYNCSO
FXXXXXXX SYSTEM z/OS 1.12.0
SYNCSORT LICENSED FOR CPU SERIAL NUMBER 1C324, MODEL 2818 W02 LICEN
SYSIN :
JOINKEYS FILE=F1,FIELDS=(59,12,A)
JOINKEYS FILE=F2,FIELDS=(97,12,A)
JOIN UNPAIRED,F1
REFORMAT FIELDS=(F1:1,140,F2:273,3,F2:701,15,F1:141,41,?)
*
SORT FIELDS=COPY
OUTFIL FNAMES=ONLYF1,INCLUDE=(200,1,CH,EQ,C'1'),
BUILD=(1,140,60X)
OUTFIL FNAMES=MATCH,INCLUDE=(200,1,CH,EQ,C'B'),
BUILD=(1,200)
WER268A REFORMAT STATEMENT: SYNTAX ERROR
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE
******************************** BOTTOM OF DATA ********************************
Can anybody please let me know what the problem is in syntax? Thanks.
Yes. As told by Bill, ? was used for record matching criteria.
So, the method suggested by Ranjith is not working.
Code:
SYSIN :
JOINKEYS FILE=F1,FIELDS=(59,12,A)
JOINKEYS FILE=F2,FIELDS=(97,12,A)
JOIN UNPAIRED,F1
REFORMAT FIELDS=(F1:1,140,F2:273,3,F2:701,15,F1:141,41),FILL=C'?'
SORT FIELDS=COPY
OUTFIL FNAMES=ONLYF1,INCLUDE=(200,1,CH,EQ,C'1'),
BUILD=(1,140,60X)
OUTFIL FNAMES=MATCH,INCLUDE=(200,1,CH,EQ,C'B'),
BUILD=(1,200)
WER276B SYSDIAG= 1094417, 1977712, 1977712, 878775
WER164B 102,532K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER164B 128K BYTES RESERVE REQUESTED, 1,004K BYTES USED
WER146B 20K BYTES OF EMERGENCY SPACE ALLOCATED
WER224A ONLYF1 NOT DEFINED
WER224A MATCH NOT DEFINED
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE
WER224A 'DDNAME' NOT DEFINED
EXPLANATION: The 'ddname' is either SORTIN,
SORTINnn, SORTOUT, SORTOFxx or SORTOFx. A re-
quired SORTIN or SORTOUT DD statement could not
be found.
Hi,
I have used the sort card provided by Skolusu on the link provided by Bill.
I am getting the same error for it also. I think '?' is not working for 1.4.0.1R version of SYNCSORT.
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
GaganGarg wrote:
I have used the sort card provided by Skolusu on the link provided by Bill.
Moreover Kolusu's solutions will be DFSORT compatible, we cannot expect it to work on Syncsort since not all DFSORT functions are supported by Syncsort, though there could be alternatives.