View previous topic :: View next topic |
Author |
Message |
nag77 Beginner
Joined: 03 Jan 2006 Posts: 11 Topics: 8
|
Posted: Fri Feb 10, 2006 1:11 am Post subject: Combine 2 files with diferent fields as 1 record |
|
|
Hi
I have two files,want to concatenate the different fields in those two files using sort step.
for example first 4 fields from the first file and last 3 fields from the second file.
thanks in advance
NAG. |
|
Back to top |
|
 |
Alain Benveniste Beginner
Joined: 04 May 2003 Posts: 92 Topics: 4 Location: Paris, France
|
Posted: Fri Feb 10, 2006 3:42 am Post subject: |
|
|
Nag,
Your example is too evasive.
Do you have duplicates in both files ?
Please give a concret example
Alain |
|
Back to top |
|
 |
Phantom Data Mgmt Moderator

Joined: 07 Jan 2003 Posts: 1056 Topics: 91 Location: The Blue Planet
|
Posted: Fri Feb 10, 2006 3:53 am Post subject: |
|
|
Nag77,
Your requirement is simple, but it has quite a few complications.
1. First we need to know what sort product do you use (Syncsort / DFSORT)
2. The version of Sort product
3. Data stored in these two files - does your input files have any duplicates.
4. What is the key field position.
5. LRECL and RECFM of input files ???
Anyway, lots of queries are already posted in this board on similar requirements. Please search before posting. Check the FAQ pages.
http://www.mvsforums.com/helpboards/viewtopic.php?t=5399
Thanks,
Phantom |
|
Back to top |
|
 |
|
|