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

JOINKEYS for Variable files


IBM Mainframe Forums -> FAQ & Basics
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
nani821

New User


Joined: 07 Nov 2022
Posts: 4
Location: India

PostPosted: Mon Nov 07, 2022 5:12 am
Reply with quote

HI am trying to get the matched rows from 2 varialbles, 1 input file is GDG and other one is VSAM, both files are variables and my o/p also variable file. I am using below SORT card but getting error.

SORT FILEDS=COPY
JOINKEYS FILE=F1,FIELDS=(29,20,A),TYPE=V
JOINKEYS FILE=F2,FIELDS=(4,10,A,16,10,A),TYPE=V
REFORMAT FIELDS=(F1:1,1200)

WER813I INSTALLATION OPTIONS IN MFX LOAD LIBRARY WILL BE USED
WER268A SORT STATEMENT : SYNTAX ERROR

Please help on this .

Thanks,
Nani
Back to top
View user's profile Send private message
Joerg.Findeisen

Senior Member


Joined: 15 Aug 2015
Posts: 1442
Location: Bamberg, Germany

PostPosted: Mon Nov 07, 2022 8:01 am
Reply with quote

No such thing FILEDS exists. RTFM. icon_rolleyes.gif

Also, please use Code Tag button to present code/data here.
Back to top
View user's profile Send private message
Joerg.Findeisen

Senior Member


Joined: 15 Aug 2015
Posts: 1442
Location: Bamberg, Germany

PostPosted: Mon Nov 07, 2022 12:45 pm
Reply with quote

After you have fixed that simple issue, you need to adjust the JOINKEYS FIELDS as these have to have the same amount/length of keys. To do that, see DD:JNF2CNTL, and use INREC for this task.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3109
Location: NYC,USA

PostPosted: Mon Nov 07, 2022 3:51 pm
Reply with quote

Welcome!
Please use code tags going forward and moved to student section.
Back to top
View user's profile Send private message
View previous topic : : View next topic  
Post new topic   Reply to topic All times are GMT + 6 Hours
Forum Index -> FAQ & Basics

 


Similar Topics
Topic Forum Replies
No new posts Alternative of JoinKeys in SORT DFSORT/ICETOOL 2
No new posts INPFIL FILES, FNAMES examples SYNCSORT 7
No new posts FileAid move data from two files to o... Compuware & Other Tools 5
No new posts Using JOINKEYS - Exclude accounts whi... SYNCSORT 10
No new posts JCL to merge two files side by side DFSORT/ICETOOL 3
Search our Forums:


Back to Top