Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
how to concatenate two diff cols in two files

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
muthupandi.

New User


Joined: 24 Jul 2012
Posts: 5
Location: india

PostPosted: Wed Aug 22, 2012 12:41 pm    Post subject: how to concatenate two diff cols in two files
Reply with quote

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 icon_cry.gif
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Wed Aug 22, 2012 12:45 pm    Post subject: Reply to: how to concatenate two diff cols in two files
Reply with quote

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
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Aug 22, 2012 2:26 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Jaggu.r

New User


Joined: 07 Aug 2012
Posts: 2
Location: India

PostPosted: Wed Aug 22, 2012 6:06 pm    Post subject: Reply to: how to concatenate two diff cols in two files
Reply with quote

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
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Wed Aug 22, 2012 6:35 pm    Post subject: Reply to: how to concatenate two diff cols in two files
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10310
Location: italy

PostPosted: Wed Aug 22, 2012 6:39 pm    Post subject: Reply to: how to concatenate two diff cols in two files
Reply with quote

I noticed that in the last two posts the TS simply disappeared.
good luck, have a nice time waiting icon_wink.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Comparing 2 Files using Current time arunsoods DFSORT/ICETOOL 2 Fri Sep 22, 2017 6:00 pm
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts Join records from 2 files with No Dup... Poha Eater DFSORT/ICETOOL 21 Sun Aug 27, 2017 10:35 pm
No new posts Match two files using multiple keys a... santoshks1987 SYNCSORT 11 Fri Aug 18, 2017 10:50 am
No new posts Multiple VSAM files single output fil... Mohan Kothakota DFSORT/ICETOOL 11 Wed Aug 09, 2017 7:57 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us