Page 2 of 2

Posted: Sat Feb 07, 2009 11:42 am
by Anuj Dhawan
Have a good one.. :) ,

Ad

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

Posted: Tue Jun 02, 2009 11:51 pm
by Alissa Margulies
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.

Merge duplicate records in the same file

Posted: Thu Jul 11, 2013 12:19 pm
by raulravi
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

Posted: Thu Jul 11, 2013 9:34 pm
by DikDude
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?