concatenate 3 input records in different ds into one record

In this Mainframe Forum - You can post your queries on JCL, OS/390 JCL, MVS JCL, z/OS JCL, JES2 & JES3

Moderators: Frank Yaeger, DikDude, Moderator Group

Post Reply
bhargavi_ns
Member
Posts: 18
Joined: Wed Sep 21, 2011 9:47 am

concatenate 3 input records in different ds into one record

Post by bhargavi_ns » Thu Mar 21, 2013 11:21 am

I want to concatenate 3 input records in different dataset into one record in output dataset:

input1:
99abcdefghijklmno

input2:
123456789

input3:
987654321

Required output:
99abcdefghijklmno 123456789 987654321

bhargavi_ns
Member
Posts: 18
Joined: Wed Sep 21, 2011 9:47 am

Post by bhargavi_ns » Thu Mar 21, 2013 11:59 am

I am able to do this using SAS.
But need to try using ICETOOL or SORT.

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Thu Mar 21, 2013 3:08 pm

Please have a look at RESIZE parameter for DFSort.
Regards,
Anuj

William Collins
Active Member
Posts: 732
Joined: Thu May 24, 2012 4:07 am

Post by William Collins » Fri Mar 22, 2013 4:38 am

What are the RECFMs and LRECLs of your inputs? You have one record on each file?

tamilselvan.sampath
Member
Posts: 26
Joined: Mon Jan 23, 2012 11:17 pm

Post by tamilselvan.sampath » Sun Mar 24, 2013 2:27 am

You can use joinkeys fuction in dfsort

William Collins
Active Member
Posts: 732
Joined: Thu May 24, 2012 4:07 am

Post by William Collins » Sun Mar 24, 2013 3:29 am

tamilselvan.sampath wrote:You can use joinkeys fuction in dfsort
Possibly, but probably not necessary, and you don't know for sure one way or the other without knowing the information already asked, and not yet supplied.

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others