to merge 2 records of the input file using SORT

In this Mainframe Forum - You can post your queries on DFSORT, ICETOOL , SyncSort & JCL Utilities

Moderators: Frank Yaeger, Moderator Group

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

Post by Anuj Dhawan » Sat Feb 07, 2009 11:42 am

Have a good one.. :) ,

Ad

Alissa Margulies
Member
Posts: 25
Joined: Tue Apr 28, 2009 10:53 pm
Location: USA
Contact:

Re: to merge 2 records of the input file using SORT

Post by Alissa Margulies » Tue Jun 02, 2009 11:51 pm

kanna wrote:how could i achieve the same in syncsort?
Support for WHEN=GROUP was included in SyncSort for z/OS 1.3.2. The JCL provided will work on the current release of SyncSort.
Alissa Margulies
SyncSort Mainframe Product Services
zos_tech@syncsort.com
201-930-8260

raulravi
Member
Posts: 47
Joined: Mon Apr 18, 2011 9:51 am
Location: India

Merge duplicate records in the same file

Post by raulravi » Thu Jul 11, 2013 12:19 pm

Input file: (FB/80)

Code: Select all

OWGU801D  @@DB2DSN
OWGU801D  G@OWFSOR
OWGU802D  @@DB2DSN
OWGU802D  G@OWFCRD
OWGU801D  G@OWFRRR
I have to merge the two records in the I/P file based on the key(1:8)

Expected Output file: (FB/80)

Code: Select all

OWGU801D  @@DB2DSN / G@OWFSOR / G@OWFRRR
OWGU802D  @@DB2DSN / G@OWFCRD
Is there any way to do this using DFSORT or ICETOOL?

Your help is appreciated.

Regards

Raul

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Thu Jul 11, 2013 9:34 pm

When you have a question, you should start a new topic for your question rather than replying to a topic that has been dormant for 4 years . . .

However, Frank provided an answer earlier in this topic . . . What happens when you apply Frank's solution?
Have a good one

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