IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Need help on ICETOOL


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
rahul sijoriya

New User


Joined: 08 Jan 2007
Posts: 11
Location: hyderabad

PostPosted: Wed Dec 18, 2013 6:37 am
Reply with quote

Hello All,
I need help to merge two records from different file using same key..in below example key is "STATUS"



File 1 :

123456789STATUS
111111111STATUS
222222222STATUS
134567834STATUS

File2:
STATUSINITIAL




I want output:
123456789INITIAL
111111111INITIAL
222222222INITIAL
134567834INITIAL

Please help me to write JCL using ICETOOL.
Back to top
View user's profile Send private message
Pandora-Box

Global Moderator


Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy

PostPosted: Wed Dec 18, 2013 9:19 am
Reply with quote

Could you please post the product and version used in your shop?
Back to top
View user's profile Send private message
rahul sijoriya

New User


Joined: 08 Jan 2007
Posts: 11
Location: hyderabad

PostPosted: Wed Dec 18, 2013 9:45 am
Reply with quote

Please suggest what you mean by product and version?
Back to top
View user's profile Send private message
Pandora-Box

Global Moderator


Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy

PostPosted: Wed Dec 18, 2013 9:51 am
Reply with quote

Product : DFSORT or SYNCSORT?
Back to top
View user's profile Send private message
rahul sijoriya

New User


Joined: 08 Jan 2007
Posts: 11
Location: hyderabad

PostPosted: Wed Dec 18, 2013 10:00 am
Reply with quote

I used to have PGM=SORT in my jcl
Back to top
View user's profile Send private message
rahul sijoriya

New User


Joined: 08 Jan 2007
Posts: 11
Location: hyderabad

PostPosted: Wed Dec 18, 2013 10:27 am
Reply with quote

Its DFSORT
Back to top
View user's profile Send private message
Pandora-Box

Global Moderator


Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy

PostPosted: Wed Dec 18, 2013 10:58 am
Reply with quote

Ok and the version is ?


Please execute this step and let us know the SYSOUT

Code:
//S1 EXEC PGM=ICEMAN
//SYSOUT   DD SYSOUT=*
//SORTIN DD *
RECORD
/*
//SORTOUT DD DUMMY
//SYSIN   DD   *
  OPTION COPY
/*
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1702
Location: Australia

PostPosted: Wed Dec 18, 2013 11:05 am
Reply with quote

Hi,

if there is only 1 record in File 2, create a SYMNAMES from it and pass it to Step2 and use OVERLAY.


Gerry
Back to top
View user's profile Send private message
Pandora-Box

Global Moderator


Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy

PostPosted: Wed Dec 18, 2013 11:09 am
Reply with quote

gcicchet,

Yes that is indeed "the" best solution but I am just trying to understand from TS his sort version if it would support SYMNAMES.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK

PostPosted: Wed Dec 18, 2013 2:44 pm
Reply with quote

For someone who has been here 6 years, cannot use code tags, does not supply LRECL or RECFM, does not know what is meant by Product and Version, thinks ICETOOL can produce JCL (which it could but the requirement is actually with sort control cards which are not JCL), posts in the DFsort/ICETOOL part of the forum which obviously means that he is requiring help with that product so why title the post "Need help on ICETOOL"...

And why ICETOOL - it can probably be done with plain vanilla DFSort.
Back to top
View user's profile Send private message
rahul sijoriya

New User


Joined: 08 Jan 2007
Posts: 11
Location: hyderabad

PostPosted: Wed Dec 18, 2013 5:46 pm
Reply with quote

Dear Nic, I never used this forum earlier. So not much aware about it ..I am sorry if I have done any mistake in my post..
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Wed Dec 18, 2013 7:33 pm
Reply with quote

Hello,

Quote:
I am sorry if I have done any mistake in my post..
Not to worry - we were all new to forum etiquette once upon a time.

When you were asked to run:
Code:
//S1 EXEC PGM=ICEMAN
//SYSOUT   DD SYSOUT=*
//SORTIN DD *
RECORD
/*
//SORTOUT DD DUMMY
//SYSIN   DD   *
  OPTION COPY
/*

it was to provide info we might need in order to help you. That execution will provide information about your version and release of the sort product.
Back to top
View user's profile Send private message
rahul sijoriya

New User


Joined: 08 Jan 2007
Posts: 11
Location: hyderabad

PostPosted: Wed Dec 18, 2013 9:02 pm
Reply with quote

I ran the ICEMAN posted in the chain.

And here is the Product and version. I believe this is what you guys are looking for.

Code:

****  SYNCSORT FOR Z/OS R 1.4    ****   z/OS 
Back to top
View user's profile Send private message
Pandora-Box

Global Moderator


Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy

PostPosted: Wed Dec 18, 2013 9:10 pm
Reply with quote

Finally the cat is out of the bag .. God bless you icon_smile.gif

FYI Syncsort queries needs to be posted on JCL forum and anyway you dont need to raise a new question again.

Probably some moderator who reads it will move there

And Please check the SYCNSORT manual for R 1.4 and check if supports "SYMNAMES"

If Symnames is not supported in R 1.4 Joinkeys is a better option
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Wed Dec 18, 2013 11:05 pm
Reply with quote

Hello,

Quote:
I believe this is what you guys are looking for.
Yup - that is what we were looking for.

Notice that your system is running Syncsort (rather than DFSORT).

For this particular question, it is not an issue. For others it can be. Syncsort and DFSORT are quite similar, but they are Not Exactly the same. They are competing products from diffetent vendors.

Also, different features (i.e. SYNMANES) became available at different times in various versions of each product.



And yes, i'll relocate this icon_wink.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Shift left VB record without x00 endi... DFSORT/ICETOOL 11
No new posts how to calculate SUM value for VB fil... DFSORT/ICETOOL 1
No new posts how to calculate SUM for VB file usin... JCL & VSAM 1
No new posts Null values are considered in Total c... DFSORT/ICETOOL 6
No new posts ICETOOL to Read records SMF CEF it is... DFSORT/ICETOOL 4
Search our Forums:

Back to Top