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

Pavankumar.m · New User Joined: 28 Nov 2010 Posts: 53 Location: Mumbai

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.

gcicchet · Posted: Mon Jun 04, 2012 10:39 am

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

Pavankumar.m · New User Joined: 28 Nov 2010 Posts: 53 Location: Mumbai

The error message that iam getting is...

"Xsum is not supported - use icetool select if appropriate outfile"

Bill Woodger · Posted: Mon Jun 04, 2012 10:52 am

Have a look at the Smart DF Sort Tricks.

Pandora-Box · Posted: Mon Jun 04, 2012 10:54 am

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

Prakash J · New User Joined: 23 May 2012 Posts: 14 Location: India

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

Pavankumar.m · New User Joined: 28 Nov 2010 Posts: 53 Location: Mumbai

I got the syntax for this using dfsort trick document.

Skolusu · Posted: Mon Jun 04, 2012 10:35 pm

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:

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

rakesha.hg · Posted: Tue Jun 05, 2012 5:53 pm