Help required in Join keys



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

Re: Help required in Join keys

Postby tjegan » Mon Nov 03, 2014 12:02 pm

Thanks a ton. The above source is working fine :)
tjegan
 
Posts: 34
Joined: Mon Mar 25, 2013 5:58 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Re: Help required in Join keys

 

Re: Help required in Join keys

Postby tjegan » Fri Nov 07, 2014 7:11 pm

The above control statement works fine if the input file1 contains the duplicate value. Could you please share me the control card if
input file2 also contains the duplicate value.

When i try with the above control statement, i am getting the below output.
Input File1
1000 ARUN A
1001 BALA B
1001 BALA D
1001 AAAA D
1001 BBBB D
1007 CHAN C

Input file2:
1001 BALA 1     
1003 KATE 2     
1001 JOHN 5     
1004 EDWIN 3     

Output:
1001 BALA B 
1001 BALA 1 
1001 BALA B 
1001 BALA D 
1001 BALA D 
1001 AAAA D 
1001 AAAA D 
1001 BBBB D 
1001 BBBB D 

Expected output:
1001 BALA B
1001 BALA D
1001 AAAA D
1001 BBBB D
1001 BALA 1     
1001 JOHN 5     


Many thanks in advance.
tjegan
 
Posts: 34
Joined: Mon Mar 25, 2013 5:58 pm
Has thanked: 0 time
Been thanked: 0 time

Previous

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post