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

MORE REGS THAT EXPECTED USING JOINKEYS


IBM Mainframe Forums -> SYNCSORT
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
06650998

New User


Joined: 20 Jul 2021
Posts: 1
Location: PERU

PostPosted: Tue Jul 20, 2021 10:14 pm
Reply with quote

I HAVE PROCESSED JOINKEYS FOR TWO FILES OF LENGTH=242, FILE INPUT=39 REGS, PAIRED=37 AND THE NEXT FILE HAS 38 RGS, PAIRED=34, BUT THE FILE OUTPUT RESULTS OUT 247 REGS

DOES ANYONE KNOW WHY IS THAT??

ATTACH SORT REPORT.
Back to top
View user's profile Send private message
Joerg.Findeisen

Senior Member


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

PostPosted: Tue Jul 20, 2021 10:33 pm
Reply with quote

Expect nobody to download attached unverified files. Also ALL UPERCASE QUESTIONS are being ignored as it is considered unrude. Please respecify what is wrong, providing Input/Output/Err Msgs of your code. Simple as that.
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 2024
Location: USA

PostPosted: Tue Jul 20, 2021 11:05 pm
Reply with quote

06650998 wrote:
DOES ANYONE KNOW WHY IS THAT??

Because:
Quote:
There’ll be trouble if the cobbler starts making pies.

1) read and learn the Forum rules
2) learn the basics of the table processing technics
3) do some training in that area
4) try to make initial research of the problem by yourself
5) try to make some experiments by changing your code and/or your data, and to verify the difference

Only after 1-5 have been completed try the next steps:

6) exclude irrelevant information (95%) from your question
7) include the required, but missing information on your issue, using the formats and styles recommended by the Forum rules.
Back to top
View user's profile Send private message
Joerg.Findeisen

Senior Member


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

PostPosted: Thu Jul 22, 2021 3:53 am
Reply with quote

Topic should be moved to SYNCSORT Section of the forum. icon_exclaim.gif
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


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

PostPosted: Thu Jul 22, 2021 4:35 am
Reply with quote

Welcome!
It should have been145,03,A. Retry.
Please follow the rules as mentioned above as a reminder.
Back to top
View user's profile Send private message
Joerg.Findeisen

Senior Member


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

PostPosted: Thu Jul 22, 2021 4:46 am
Reply with quote

Rohit Umarjikar wrote:
It should have been 145,03,A

How do you know without the data?
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 2024
Location: USA

PostPosted: Thu Jul 22, 2021 6:23 am
Reply with quote

Joerg.Findeisen wrote:
Rohit Umarjikar wrote:
It should have been 145,03,A

How do you know without the data?

A Random Number Generator?
Back to top
View user's profile Send private message
Joerg.Findeisen

Senior Member


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

PostPosted: Thu Jul 22, 2021 11:35 am
Reply with quote

sergeyken wrote:
A Random Number Generator?
You could write any number here w/o using a machine. icon_wink.gif
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


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

PostPosted: Thu Jul 22, 2021 6:50 pm
Reply with quote

Joerg.Findeisen wrote:
Rohit Umarjikar wrote:
It should have been 145,03,A

How do you know without the data?
I don't but there is no right way to get results when 3 bytes joined with 10 bytes. If TS really interested further we should see sample data else its going to be a close guess work based on what has been shared.

So I suggest , we must wait further and give a chance for TS to respond before we talk off topics.
Back to top
View user's profile Send private message
Joerg.Findeisen

Senior Member


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

PostPosted: Sat Jul 24, 2021 6:38 am
Reply with quote

Rohit Umarjikar wrote:
I don't but there is no right way to get results when 3 bytes joined with 10 bytes.
Keys have to be of same length, so the logic of the Join process is basically wrong to what's intended.
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 -> SYNCSORT

 


Similar Topics
Topic Forum Replies
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
No new posts JOINKEYS, how to keep all occurrences? DFSORT/ICETOOL 2
Search our Forums:

Back to Top