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

SYNCSORT: issue with sort card


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
GaganGarg

Active User


Joined: 31 Mar 2010
Posts: 134
Location: India

PostPosted: Thu Jun 13, 2013 12:36 pm
Reply with quote

Hi,
I'm facing some issue with sort card in SYNCSORT.

The sort card that i'm using is :

Code:


   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)                                             
 


Error message looks like:

Code:

********************************* 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.
Back to top
View user's profile Send private message
Ranjithkumar

New User


Joined: 10 Sep 2008
Posts: 93
Location: India

PostPosted: Thu Jun 13, 2013 12:43 pm
Reply with quote

If you are expecting '?' to appear in the unpaired record output the syntax should be as below:
Code:
REFORMAT FIELDS=(F1:1,140,F2:273,3,F2:701,15,F1:141,41),FILL=C'?'
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Thu Jun 13, 2013 12:47 pm
Reply with quote

No, it was an attempt to use the "match marker".

We had another user with 1.4.0.1R who said the ? worked :-)

For now, use the FILL technique (examples here) and contact SyncSort support. Let us know what they say, please.
Back to top
View user's profile Send private message
GaganGarg

Active User


Joined: 31 Mar 2010
Posts: 134
Location: India

PostPosted: Thu Jun 13, 2013 12:55 pm
Reply with quote

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                                 
Back to top
View user's profile Send private message
Ranjithkumar

New User


Joined: 10 Sep 2008
Posts: 93
Location: India

PostPosted: Thu Jun 13, 2013 1:00 pm
Reply with quote

GaganGarg

Did you check what is WER224A ?
Code:
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.                                           
Back to top
View user's profile Send private message
GaganGarg

Active User


Joined: 31 Mar 2010
Posts: 134
Location: India

PostPosted: Thu Jun 13, 2013 1:03 pm
Reply with quote

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.
Back to top
View user's profile Send private message
Pandora-Box

Global Moderator


Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy

PostPosted: Thu Jun 13, 2013 1:39 pm
Reply with quote

Gagan,

Bill stated

Quote:
with at least 1.4.1.0R, SyncSorters can use the ? in the REFORMAT statement :-)


and you are in 1.4.0.1R version of SYNCSORT.

You could try to fill X'FF' and also define

Code:
 WER224A  ONLYF1   NOT DEFINED                                                 
 WER224A  MATCH    NOT DEFINED         
Back to top
View user's profile Send private message
Arun Raj

Moderator


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

PostPosted: Thu Jun 13, 2013 2:25 pm
Reply with quote

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.
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 How to split large record length file... DFSORT/ICETOOL 10
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts JCL sort card - get first day and las... JCL & VSAM 9
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
Search our Forums:

Back to Top