Need help with MERGE

IBM's Sort Product, ICETOOL, ICEMAN and ICEGENER.
Post Reply
pyro_wood
New Member
Posts: 1
Joined: Sun Sep 28, 2014 7:44 pm

Need help with MERGE

Post by pyro_wood »

Hi,

I'm relatively new to the whole mainframe thingy and I need some help on a task.

I need to MERGE two Datasets together.
I'm working on a TSO/E environment.


The datasets look like....

DSN='NEW'

Code: Select all

0100    Peter, Bauer
0200    Hans, Zimmer
0300    Michael, Bender
DSN='OLD'

Code: Select all

0100    Peter, Bauer
0200    Hans, Zimmer
0300    Michael, Bender
0400    Maria, Brunn

I want to MERGE the 'OLD' DSN with the 'NEW' DSN.

End result should look like this:

Code: Select all

0100    Peter, Bauer
0200    Peter, Bauer
0300    Hans, Zimmer
0400    Hans, Zimmer
0500    Michael, Bender
0600    Michael, Bender
0700    Maria, Brunn



I tried to initialise DFSORT over JCL with a Statement from a PDF named 'Getting Started with DFSORT' by IBM.
It did not work sadly. It always shows a SYNTAX ERROR, that does not exist in the JCL...



Can anyone give me a suggestion for a working JCL statement?

The RECFM of both the datasets new and old are on 'FB'... could this be a problem?

Is there another solution for combining two datasets with each other?
William Collins
Global Moderator
Global Moderator
Posts: 490
Joined: Sun Aug 25, 2013 7:24 pm

Re: Need help with MERGE

Post by William Collins »

JCL does no data-manipulation for you. DFSORT does a lot. You need either the DFSORT Messages and Codes manual, or to use IBM's LOOKAT web-service, where you enter the error-message number in a box, click on GO and it shows you the text of the message.

Of you post the sysout of the failing step here, and we have a look.
Ashit Shah
New Member
Posts: 7
Joined: Thu Apr 24, 2014 12:00 pm

Re: Need help with MERGE

Post by Ashit Shah »

hello pyro_wood,

Are the numbers part of your data?
Post Reply

Create an account or sign in to join the discussion

You need to be a member in order to post a reply

Create an account

Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute

Register

Sign in

Return to “IBM DFSort, ICETOOL, ICEMAN, ICEGENER.”