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: 1338
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: 1338
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: 3076
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> FAQ & Basics

 


Similar Topics
Topic Forum Replies
No new posts 3 files concatenated to 1 DFSORT/ICETOOL 2
No new posts JCL sort to compare dates in two file... DFSORT/ICETOOL 2
No new posts REXX/CMS How to place command console... CLIST & REXX 4
No new posts CA7 count with DATE variable CA Products 0
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 3
Search our Forums:

Back to Top