JOINKEYS for Variable files



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

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
______
naga821
 
Posts: 4
Joined: Fri Oct 28, 2022 10:04 am
Has thanked: 0 time
Been thanked: 0 time

Re: JOINKEYS for Variable files

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

SORT FILEDS=COPY


SORT STATEMENT : SYNTAX ERROR
Javas and Pythons come and go, but JCL and SORT stay forever.
User avatar
sergeyken
 
Posts: 408
Joined: Wed Jul 24, 2019 10:12 pm
Has thanked: 6 times
Been thanked: 40 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post