Page 1 of 1

Merging two GDG's

PostPosted: Sat Apr 21, 2012 12:58 am
by pushkal2gud
Hi Forum,

I want to merge two GDG into a PS file in the following pattern.

GDG1
Apple
Banana
Canada
Dog

GDG2
Banana
Canada
Dog

Merged PS
Apple

It means that when the two GDG's are merged then it should exclude the same data.

Any help would be appreciated.

Regards
Pushkal

Re: Merging two GDG's

PostPosted: Sat Apr 21, 2012 1:13 am
by dick scherrer
Hello and welcome to the forum,

There is no reason to treat gdg generations any differently than other sequential files. . .

Look in the forum for topics that mention JOINKEYS in the discussion. There are multiple examples available.

Re: Merging two GDG's

PostPosted: Sat Apr 21, 2012 1:16 am
by BillyBoyo
It is irrelevant that the input is two generations of the same GDG. They are just sequential files for all that anything is known by a program.

It would be a very simple JOINKEYS application for your Sort product.

Is that really the data, or are you going to produce the actual code afterwards?

What are the RECFMs of the inputs and output?

What is your Sort product? If you don't know, look at the messages out of a Sort step. If they start ICE it is DFSORT, if WER it is Syncsort.

'evening Dick :-)

Re: Merging two GDG's

PostPosted: Sat Apr 21, 2012 6:47 pm
by dick scherrer
'Mornin' Billy,

I was on the way out when we last posted<g> It was mid-afternoon here.

Have a good one!

d

Re: Merging two GDG's

PostPosted: Wed Apr 25, 2012 3:04 am
by pushkal2gud
Hi dick and billy,

Thanks for your help. I was able to do it using joinkeys. It was a new concept for me.

Regards
Pushkal

Re: Merging two GDG's

PostPosted: Wed Apr 25, 2012 3:07 am
by dick scherrer
Good to hear it is working - thank you for letting us know :)

d