IBM Mainframe Forum

Hello,

I understand the proposed solution by Oliver.

Sorry, but it does not appear so. . .

d

Hi Oliver,
First of all I would like to tell please don't think that I am expecting the exact solution in the forum.I just asked my query when I found that the solution proposed by you will not fit properly.I understand join key can join files with joining key at different places of the file but as far as I understand at one time only one position from each of the file can be used for join.
For example:
File1:
12345 XXXXX
11111 YYYYY 67890
File2:
YYYYY BBBBB 12345
MMMM CCCC 67890
so in these files if we use
JOINKEYS F1=FILE1,FIELDS=(1,5,A)
JOINKEYS F2=FILE2,FIELDS=(13,5,A) then for the second record the join won't work. May be I am more clear now.
The output we got from Join1 and L1 file can not be joined as we have the common keys at different places in JOIN1 output file.
While trying out to get something from your solution something came to my mind:
We can split the driver file L1 to 3 files as per L1-FILE CODE=BS,ED,NA.
Then for each file we can perform different Join with Driver file and at end once again concatenate all the output.

Have you actually tried joining 2 files with keys in different positions? I would think it a bit silly if you could not. For a start, why would you have to specify the key details twice if they were the same?

I guess there is some confusion Nic. May be my explanation was not clear when I was saying at different positions I meant in the same file.
Please go through all the previous post.Then you would be having a clear picture of the output of JOIN1 as suggested by Oliver and then either you will realize that the JOIN2 is not possible or clarify my misunderstanding and misinterpetation of the solution.

Hello ajuatsgp,

When I try to join ED12 and BX12 this is a possible result (I tried it "hands on"):

1111222200022221111 1234567890987654321 0 1111111111111111111 3333444400033334444 1234567890987654321
1111333300033331111 1234567890987654321 1 2222222222222222222 3333444400033334444 9999999990123456789
4444888800088884444 9876543210123456789 1 3333333333333333333 5555444400055554444 9876543210123456789
4444555500055554444 1234432100123456789 0 4444444444444444444 3333444400033334444 1234567890987654321
4444676700067674444 9999999990123456789 0 5555555555555555555 3333444400033334444 9999999990123456789
4444999900099994444 9999999990123456789 1 6666666666666666666 3333444400033334444 9999999990123456789

Can you show and explain to me, how now your DRIVER file stands in relation to this?
If you look at the bold marked fields, how do you want to decide which date-field matches to another field in ED/BX, because there are duplicate values?

2012153121517181BS 1234567890987654321
2012153121517182BS 1234567890987654321
2012153131421191BS 9876543210123456789
2012153121919361ED 1111222200022221111
2012153121919361NA 3333444400033334444

I need something like: If 'BS' --> KEY at position x in length y, If 'ED' --> KEY at position z length l and so on...

Perhaps this will help me to understand what you need exactly. At the moment there are just duplicate keys and inconsistencies...
When you need information out of all files in the output dataset there has to be something UNIQUE, that I (or any programmer) can use

Regards,

Oliver

While trying out to get something from your solution something came to my mind:
We can split the driver file L1 to 3 files as per L1-FILE CODE=BS,ED,NA.

I did that already in one of my posts

I did that already in one of my posts

but he does not know that because he hasn't tried anything yet, by the sounds of it.

Sorry but with no offence to anyone..I am just leaving this post thread.I don't know why but most people here thinks that I didn't try anything of myself or I am expecting the complete output from here,may be because my way of asking query is improper or I am unable to show what I tried. I will try out something myself or may be will write a conventional COBOL program as many people do.
I really got more people commenting than trying to understand what I am saying.
Once again applogoy,I don't want to offence any one I know all here are very much knowledgeous and they have lots of other imporant work than just replying to me
Thanks.

Hello,

I really got more people commenting than trying to understand what I am saying.

Well, you are quite mistaken. . . Everyone here has tried to understand - but to no avail. . . And yes, you do need to work on how you present your info.

Comments are often made when the requirement is not clear or the requested info is not presented in some usable fashion.

One (if not the most) important part of getting help is a consistent understanding between the person with the question (helpee) and the helpers.

If no one was trying to understand, this topic would not have gone to 4 pages.

I think it is significant that the DFSort team pulled out of this thread a long time ago!