Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Need help on ICETOOL

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
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    Post subject: Need help on ICETOOL
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

Moderator


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

PostPosted: Wed Dec 18, 2013 9:19 am    Post subject:
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    Post subject:
Reply with quote

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

Moderator


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

PostPosted: Wed Dec 18, 2013 9:51 am    Post subject:
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    Post subject:
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    Post subject: Reply to: Need help on ICETOOL
Reply with quote

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

Moderator


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

PostPosted: Wed Dec 18, 2013 10:58 am    Post subject:
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: 1703
Location: Australia

PostPosted: Wed Dec 18, 2013 11:05 am    Post subject:
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

Moderator


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

PostPosted: Wed Dec 18, 2013 11:09 am    Post subject:
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: 1717
Location: UK

PostPosted: Wed Dec 18, 2013 2:44 pm    Post subject:
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    Post subject: Reply to: Need help on ICETOOL
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

Site Director


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

PostPosted: Wed Dec 18, 2013 7:33 pm    Post subject:
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    Post subject: Reply to: Need help on ICETOOL
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

Moderator


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

PostPosted: Wed Dec 18, 2013 9:10 pm    Post subject:
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

Site Director


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

PostPosted: Wed Dec 18, 2013 11:05 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to delete second instance from Fl... Gunapala CN DFSORT/ICETOOL 6 Tue Oct 18, 2016 11:42 pm
No new posts ICETOOL/SYNCSORT - SYSPRINT output nartcr DFSORT/ICETOOL 17 Wed Oct 05, 2016 10:46 pm
No new posts Icetool or Joinkeys example to compar... ishant chauhan DFSORT/ICETOOL 21 Sat Aug 20, 2016 2:40 am
No new posts ICETOOL higher option Anshul Das DFSORT/ICETOOL 14 Thu Apr 14, 2016 8:00 am
No new posts Compare Files and extract matching re... vimalravi83 DFSORT/ICETOOL 3 Wed Jan 06, 2016 2:42 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us