MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Load a table after removing Dups
Goto page Previous  1, 2
 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
vak255
Intermediate


Joined: 10 Sep 2004
Posts: 384
Topics: 79
PostPosted: Tue Jun 12, 2012 11:15 pm    Post subject: Reply with quote
I submitted the Job. Now I am getting the be low error. Syntax error.
I believe this is because we are using SYNCSORT and not DFSORT.

Code:
DCHA - ABENDED S000 U0016



Code:
 SYNCSORT FOR Z/OS  1.3.2.1N    U.S. PATENTS: 421096

 SYNCSORT LICENSED FOR CPU SERIAL NUMBER 11A44, MODE
 SYSIN :
   OPTION COPY
   JOINKEYS F1=INA,FIELDS=(1,9,A)
            *
   JOINKEYS F2=INB,FIELDS=(1,9,A),SORTED,NOSEQCK
            *
   JOIN UNPAIRED,F1,ONLY
 WER268A  JOINKEYS STATEMENT: SYNTAX ERROR
 WER268A  JOINKEYS STATEMENT: SYNTAX ERROR
 WER211B  SYNCSMF  CALLED BY SYNCSORT; RC=0000
 WER449I  SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE
 ******************************* Bottom of Data ****
Back to top
View user's profile Send private message
Nic Clouston
Advanced


Joined: 01 Feb 2007
Posts: 1075
Topics: 7
Location: At Home
PostPosted: Wed Jun 13, 2012 12:43 am    Post subject: Reply with quote
Well, you will have to wait for a SYNCSORTer to come along or read the manual. Kolusu cannot answer your questions as he is a DFSort developer and SYNCSORT is a competing product.
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.
Back to top
View user's profile Send private message
vak255
Intermediate


Joined: 10 Sep 2004
Posts: 384
Topics: 79
PostPosted: Wed Jun 13, 2012 1:29 am    Post subject: Reply with quote
k, got it. Thanks Nic.
Back to top
View user's profile Send private message
papadi
Supermod


Joined: 20 Oct 2009
Posts: 594
Topics: 1
PostPosted: Wed Jun 13, 2012 8:56 am    Post subject: Reply with quote
Your JOINKEYS statements are not correct.

Code:

//SORTJNF1 DD DSN=whatever
//SORTJNF2 DD DSN=whatever


 JOINKEYS FILE=F1,FIELDS=(01,12,A)
 JOINKEYS FILE=F2,FIELDS=(01,12,A)

works.
_________________
All the best,

di
Back to top
View user's profile Send private message
vak255
Intermediate


Joined: 10 Sep 2004
Posts: 384
Topics: 79
PostPosted: Wed Jun 13, 2012 10:04 am    Post subject: Reply with quote
Yes, I corrected it.

what is the syncsort euivalent statement for "JOIN UNPAIRED,F1,ONLY"
As I want to get the non-matching records to the output file.
Back to top
View user's profile Send private message
vak255
Intermediate


Joined: 10 Sep 2004
Posts: 384
Topics: 79
PostPosted: Wed Jun 13, 2012 10:24 am    Post subject: Reply with quote
I got it working.

Code:
 //SYSIN    DD *
   SORT FIELDS=COPY
   JOINKEYS FILE=F1,FIELDS=(1,9,A)
   JOINKEYS FILE=F2,FIELDS=(1,9,A)
   JOIN UNPAIRED,F1,ONLY
   REFORMAT FIELDS=(F1:01,36)
 //


Thx for all the help.
Back to top
View user's profile Send private message
papadi
Supermod


Joined: 20 Oct 2009
Posts: 594
Topics: 1
PostPosted: Wed Jun 13, 2012 2:03 pm    Post subject: Reply with quote
Good to hear it is working - thank you for posting your solution Smile

d
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Goto page Previous  1, 2
Page 2 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group