I guess it can be done
but If my understand is right, if you have only custid's in first file and 2nd file holds custid's and other details..then your output should be custid's with details..then can't we use directly the second file?
If you want only the details which custid's present on first file yes, then does that mean the number of custid's are different to second & first file?
Joined: 30 Dec 2006 Posts: 20 Location: Kolkata, India
This might be more complicated than it looks. Most tools on mainframes work row-wise, that is one row at a time. Your problem is simplified many-fold if you can get the first dataset transposed, i.e. say it is like:
Then you can do a MERGE FEILDS and get your result.
But I am not aware of any tool which can directly transpose a dataset in such fashion. To come up with a solution using existing tools will be complicated, time consuming and would probably have a lot of limitations. Try using any other technology that is available with you to do this, I bet it will be simpler.