| View previous topic :: View next topic |
| Author |
Message |
Siddheart22
Beginner
Joined: 11 Apr 2005
Posts: 42
Topics: 19
Location: India
|
 Posted: Fri Jun 30, 2006 4:26 am Post subject: File comparision. |
 |
|
hi,
I have File B with the following records
The first 4 chars are the key fields.
1234TREVOR
1111REBELO
I have File A with the following records
Each key of file B CAN have multiple records in file A.
1234ABCD
1234EFGH
2222KKKK
1111LMNO
I need the Output File such that the 10 characters following the key in file B are appended to the respective reocrds in file A.
1234ABCDTREVOR
1234EFGHTREVOR
2222KKKK
1111LMNOREBELO
How can we do this through a JCL?
Do we have something simillar to JOINS in DB2 for files.
Thanks & Regards, |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Fri Jun 30, 2006 4:59 am Post subject: |
|
|
Siddheart22,
You will NOT receive an answer on this board for the following reasons.
1. Failed to SEARCH before posting despite reminding you about it several times.
2. Posting the questions in wrong forum. This question belongs to Utilities or JCL forim.
3. You never posted feedback to the solutions you received here
4. This Id is being shared by more than 1 person
Thanks
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
