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: 1255
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: 1255
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: 3053
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 Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts Write line by line from two files DFSORT/ICETOOL 7
No new posts Compare only first records of the fil... SYNCSORT 7
Search our Forums:

Back to Top