Dividing the total count by 3 will give the actual group record count and we can remove following code, but i don't know how to do it here. Please advise if this is possible.
Joined: 26 Nov 2002 Posts: 12358 Topics: 75 Location: San Jose
Posted: Thu Aug 25, 2016 4:12 pm Post subject:
Magesh_J,
I am confused at your requirement. Do you want to find the number of group after the JOIN or just within the first file? _________________ Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
Joined: 26 Nov 2002 Posts: 12358 Topics: 75 Location: San Jose
Posted: Thu Aug 25, 2016 6:23 pm Post subject:
Magesh_J,
It is quite simple. Stop focusing on the idea of dividing by 3. You can use the JOIN indicator to figure out the count. If the JOIN indicator is "B" that means it matched, so you can check that indicator and actual group indicator of "1" So if the combination is B1 then obviously it is match and you need to count that as 1 group.
So here is a JCL which will give you the desired results. I also changed your Symnames to handle the System symbols. I assumed you wanted the current date in MMDDYY format.
Joined: 26 Nov 2002 Posts: 12358 Topics: 75 Location: San Jose
Posted: Fri Oct 21, 2016 8:53 pm Post subject:
Magesh_J wrote:
Hi Kolusu,
Please add INCLUDE COND in the main task, since UNPAIRED, F1 gives matching + unmatched F1.
But we need matched record only
Code:
INCLUDE COND=(81,1,CH,EQ,C'B')
thanks
Magesh
huh? If your intention is to just get the matched records, why bother with having the JOIN statement. The Default of Joinkeys is getting matched records. So if you eliminate the JOIN UNPAIRED,F1 statement completely you would get ONLY the matched records and you don't even need the INCLUDE statement. _________________ Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum