Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 134
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: 7315

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: 134
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: 134
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: 1542
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: 2285
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 sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm
No new posts JOINKEYS Paired and Unpaired Sort MFwhiz DFSORT/ICETOOL 4 Fri Sep 29, 2017 1:48 am
No new posts Difference in SORT & ICETOOL Mohan Kothakota DFSORT/ICETOOL 5 Fri Sep 22, 2017 4:56 pm
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts OC4 in SORT Mohan Kothakota DFSORT/ICETOOL 2 Tue Sep 12, 2017 6:30 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us