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
 

 

SYNCSORT: issue with sort card

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

Active User


Joined: 31 Mar 2010
Posts: 132
Location: India

PostPosted: Thu Jun 13, 2013 12:36 pm    Post subject: SYNCSORT: issue with sort card
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: 94
Location: India

PostPosted: Thu Jun 13, 2013 12:43 pm    Post subject: Reply to: SYNCSORT: issue with sort card
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7241

PostPosted: Thu Jun 13, 2013 12:47 pm    Post subject: Reply to: SYNCSORT: issue with sort card
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: 132
Location: India

PostPosted: Thu Jun 13, 2013 12:55 pm    Post subject: Reply to: SYNCSORT: issue with sort card
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: 94
Location: India

PostPosted: Thu Jun 13, 2013 1:00 pm    Post subject: Reply to: SYNCSORT: issue with sort card
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: 132
Location: India

PostPosted: Thu Jun 13, 2013 1:03 pm    Post subject:
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

Moderator


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

PostPosted: Thu Jun 13, 2013 1:39 pm    Post subject:
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: 2171
Location: @my desk

PostPosted: Thu Jun 13, 2013 2:25 pm    Post subject:
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    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 syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts Syncsort - Hard coded Value in output PORYES SYNCSORT 1 Thu Nov 03, 2016 9:23 am
No new posts DFHRESPONSE returns issue divated CICS 3 Wed Nov 02, 2016 6:32 pm


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