|
View previous topic :: View next topic
|
| Author |
Message |
muthupandi.
New User
Joined: 24 Jul 2012
Posts: 5
Location: india
|
|
|
|
hi,
i have input1 having 8 cols and input 2 having 3cols that 2nd cols name and type is diff from 1st file. I want to concatenate these two files and write into another new file.
using sort is possible?
please help me  |
|
| Back to top |
|
 |
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
If the files obey the rules for concatenation, then, yes, of course it is possible.
I'd guess it is not what you want.
Do you have some rule for matching the data between the two files?
Have you looked at JOINKEYS. Many examples here. |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
| Suggest you show us some sample input records from both the files. Tell us the LRECL/RECFM of both input files and the output file and the expected output. |
|
| Back to top |
|
|
Jaggu.r
New User
Joined: 07 Aug 2012
Posts: 2
Location: India
|
|
|
|
| If you want to concatenate two files then both should be equal. if not Concatenation is not possible but JOIN is possible. Using this we can Reformat the record layout. |
|
| Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
Jaggu.r,
Do you understand what "concatenation" is? Where, in the JCL reference does it say files have to be "equal", given that you don't know the specifics of the datasets involved.
If you do understand what concatenation is, please explain how you would get that effect using JOINKEYS.
On top of that, I don't really think "concatenation" is what the TS wants, but has refused to clarify. |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
I noticed that in the last two posts the TS simply disappeared.
good luck, have a nice time waiting  |
|
| Back to top |
|
|
|
|
