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

JOINKEYS, how to keep all occurrences?


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Ali_gezer

Active User


Joined: 06 Apr 2021
Posts: 123
Location: argentina

PostPosted: Sat Apr 30, 2022 2:49 am
Reply with quote

Hello how are you?

When I execute a sort joinkeys operation I can't find how to keep all occurrences.

JOINKEYS FILE=F1,FIELDS=(1,4,A)
JOINKEYS FILE=F2,FIELDS=(1,4,A)

INPUT 1

AAAA1
AAAA2
BBBB1

INPUT 2

AAAA1
AAAA2


output
AAAA1

My need is to keep in the output file:

AAAA1
AAAA2

but only it keeps the first occurrence.

Is there a way to keep all occurrences and not just the first ?

Thanks.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


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

PostPosted: Sat Apr 30, 2022 9:21 am
Reply with quote

www.ibm.com/docs/en/zos/2.1.0?topic=files-joinkeys-application-examples
Back to top
View user's profile Send private message
Joerg.Findeisen

Senior Member


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

PostPosted: Sat Apr 30, 2022 10:33 am
Reply with quote

Ali_gezer wrote:
When I execute a sort joinkeys operation I can't find how to keep all occurrences.

Provide full SYSIN statements and remember to use Code Tags when presenting Code/Data to the forum.
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 -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Exclude rows with > than x occurre... DFSORT/ICETOOL 6
No new posts Joinkeys - 5 output files DFSORT/ICETOOL 7
No new posts PD not working for unsigned packed JO... DFSORT/ICETOOL 5
No new posts Def PD not working for unsigned packe... JCL & VSAM 3
No new posts Sort with JOINKEYS using two VB files DFSORT/ICETOOL 1
Search our Forums:

Back to Top