JOINKEYS for Variable files

IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER
naga821
Posts: 4
Joined: Fri Oct 28, 2022 10:04 am
Skillset: Mainframe
Referer: google

JOINKEYS for Variable files

Postby naga821 » Mon Nov 07, 2022 5:14 am

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
______

User avatar
sergeyken
Posts: 458
Joined: Wed Jul 24, 2019 10:12 pm
Skillset: Assembler, JCL, Utilities, PL/I, C/C++, DB2, SQL, REXX, COBOL, etc. etc. etc.
Referer: Internet search

Re: JOINKEYS for Variable files

Postby sergeyken » Tue Nov 08, 2022 7:22 pm

Code: Select all

SORT FILEDS=COPY


SORT STATEMENT : SYNTAX ERROR
Javas and Pythons come and go, but JCL and SORT stay forever.


  • Similar Topics
    Replies
    Views
    Last post