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
 

 

In icetool is there any command which is similar to xsum?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Pavankumar.m
Warnings : 1

New User


Joined: 28 Nov 2010
Posts: 53
Location: Mumbai

PostPosted: Mon Jun 04, 2012 10:31 am    Post subject: In icetool is there any command which is similar to xsum?
Reply with quote

Hi,

i want to write an sort card to write duplicate records into one file and non duplicates into another file...for this i have used xsum command but our system is not supporting xsum command...

Could you please help me how to get above sort using icetool ?

Thanks and regards,
pavan.
Back to top
View user's profile Send private message

gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Mon Jun 04, 2012 10:39 am    Post subject:
Reply with quote

Hi,

are you using DFSORT or SYNCSORT ?

As you have not shown any of your output, I'm guessing that you are using DFSORT as the XSUM parameter is a SYNCSORT function.

So look for ALLDUPS and DISCARD parameters.


Gerry
Back to top
View user's profile Send private message
Pavankumar.m
Warnings : 1

New User


Joined: 28 Nov 2010
Posts: 53
Location: Mumbai

PostPosted: Mon Jun 04, 2012 10:49 am    Post subject: I am using pgm=sort
Reply with quote

The error message that iam getting is...

"Xsum is not supported - use icetool select if appropriate outfile"
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7241

PostPosted: Mon Jun 04, 2012 10:52 am    Post subject: Reply to: In icetool is there any command which is similar t
Reply with quote

Have a look at the Smart DF Sort Tricks.
Back to top
View user's profile Send private message
Pandora-Box

Moderator


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

PostPosted: Mon Jun 04, 2012 10:54 am    Post subject:
Reply with quote

XSUM is a syncsort function

You need to use COPY , DISC search google for ICETOOL guide

I believe there should be examples in this forum

Example see here
Back to top
View user's profile Send private message
Prakash J

New User


Joined: 23 May 2012
Posts: 14
Location: India

PostPosted: Mon Jun 04, 2012 11:03 am    Post subject: Reply to: In icetool is there any command which is similar t
Reply with quote

Pavan,

If you have Smart DFSORT Tricks document, there is an example - Keep dropped duplicate records (XSUM) - Page 35. It will be helpful for you. Check it out.

- Prakash
Back to top
View user's profile Send private message
Pavankumar.m
Warnings : 1

New User


Joined: 28 Nov 2010
Posts: 53
Location: Mumbai

PostPosted: Mon Jun 04, 2012 11:26 am    Post subject: Hay thanks alot parakash..
Reply with quote

I got the syntax for this using dfsort trick document.icon_smile.gif
Back to top
View user's profile Send private message
Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Mon Jun 04, 2012 10:35 pm    Post subject: Reply to: In icetool is there any command which is similar t
Reply with quote

Pavankumar.m,

If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:

http://www.ibm.com/support/docview.wss?rs=114&uid=isg3T7000080
Back to top
View user's profile Send private message
rakesha.hg

Active User


Joined: 21 Mar 2008
Posts: 161
Location: bangalore

PostPosted: Tue Jun 05, 2012 5:53 pm    Post subject: Reply to: In icetool is there any command which is similar t
Reply with quote

Quote:
If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:

http://www.ibm.com/support/docview.wss?rs=114&uid=isg3T7000080

i loved this statement by frank (miss him icon_sad.gif) .... now we have Skolusu filling in the franks place .... best of luck icon_smile.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 What is the command to check MODE of ... rohanthengal CLIST & REXX 6 Fri Nov 18, 2016 1:48 pm
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 SDSF Command Avtrix CLIST & REXX 4 Fri Sep 30, 2016 11:13 am
No new posts How to find a CICS resource used in C... Arunkumar Chandrasekaran CICS 8 Thu Sep 29, 2016 1:45 pm


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