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
 

 

Regarding Sort Utility

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

New User


Joined: 02 Aug 2005
Posts: 13
Location: hyderabad

PostPosted: Mon Aug 22, 2005 9:30 pm    Post subject: Regarding Sort Utility
Reply with quote

Hello Friends,
Does anyone know what does this mean
SUM FIELDS=NONE,XSUM.

Someone said that the duplicate records which are to be deleted will be inserted in a new dataset which we are going to create.Does this mean?

Which Utility supports this?I have tried with SORT, it is not working.Pls suggest me the better utility.
Back to top
View user's profile Send private message

superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Mon Aug 22, 2005 10:30 pm    Post subject: Re: Regarding Sort Utility
Reply with quote

If I recall, SUM FIELDS=NONE,XSUM works for the SYNCSORT utility exactly as you were told. SUM FIELDS=NONE eliminates the duplicate records to the SORTOUT DD, and the XSUM command stores the excluded records into a separate DD (SORTXSUM, I think).
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Mon Aug 22, 2005 11:42 pm    Post subject:
Reply with quote

DFSORT does NOT support the XSUM parameter, but DFSORT's ICETOOL can perform the same function (and more) with SELECT DISCARD. For details, see:

http://www.ibm.com/servers/storage/support/software/sort/mvs/tricks/srtmst01.html#t12

Quote:
I have tried with SORT, it is not working


If you tried XSUM with DFSORT, you would have received this message:

ICE172A XSUM IS NOT SUPPORTED - USE ICETOOL SELECT IF APPROPRIATE

The Programmer Response for this message (available online) tells you exactly how to use SELECT with DISCARD to do the XSUM function.
Back to top
View user's profile Send private message
elonics

New User


Joined: 05 Jul 2005
Posts: 49
Location: India

PostPosted: Tue Aug 23, 2005 11:31 am    Post subject:
Reply with quote

Hi Sravan,
I worked on this using my JCL. So i can say that DFSORT support that control statement.


//S010 EXEC PGM=SORT
//SORTMSGS DD SYSOUT=*
//SORTWK01 DD SPACE=(TRK,(30,30),RLSE)
//SORTWK02 DD SPACE=(TRK(30,30),RLSE)
//SORTWK03 DD SPACE=(TRK,(30,30),RLSE)
//SORTIN DD DSN=A ,DISP=SHR
A = FILE WHERE DUPLCATES RECORD ARE PRESENT
//SORTOUT DD SYSOUT=*
//SORTXSUM DD DSN=OUTPUT DATASET
// UNIT=SYSDA,SPACE=(TRK,(100,100),RLSE),
// DISP=(NEW,CATLG,DELETE),
// DCB=(LRECL=100,RECFM=FB)
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSIN DD *
SUM FIELDS=NONE,XSUM
SORT FIELDS=(1,17,CH,A)
//*

The above will eliminate duplicates from the SORTIN dataset and those will be placed in SORTXSUM dataset. SORTOUT dataset contains only Unique records. Both SORTOUT and SORTXSUM datasets will be sorted out.

Along with SUM FIELDS=NONE,XSUM control statement there should be SORT FIELDS=some condition control statement. Otherwise ur JCL will lead to JCL error .


Can anyone explain me why sort statement should be present along with SUM FIELDS=NONE,XSUM ?
Back to top
View user's profile Send private message
Rupesh.Kothari

Member of the Month


Joined: 27 Apr 2005
Posts: 464

PostPosted: Tue Aug 23, 2005 12:00 pm    Post subject: Re: Regarding Sort Utility
Reply with quote

Hi,

Quote:
Can anyone explain me why sort statement should be present along with SUM FIELDS=NONE,XSUM ?


Here you will get the XSUM file which contain duplicate data in sorted order.

Regards
Rupesh
Back to top
View user's profile Send private message
elonics

New User


Joined: 05 Jul 2005
Posts: 49
Location: India

PostPosted: Tue Aug 23, 2005 12:38 pm    Post subject:
Reply with quote

Hi ,
I asked why should we use that, but not what will happen if we use that.

Regards,
Elonics.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Tue Aug 23, 2005 9:16 pm    Post subject:
Reply with quote

elonics wrote
Quote:
I worked on this using my JCL. So i can say that DFSORT support that control statement.


I repeat. DFSORT does NOT support XSUM! If XSUM did not result in an ICE172A error message, then you are using Syncsort (WERxxxs messages), not DFSORT. As a DFSORT developer, I think I know a little better than you which parameters my product supports. icon_rolleyes.gif

DFSORT does support the same function (and more) with ICETOOL using different syntax.
Back to top
View user's profile Send private message
harinatha

New User


Joined: 24 Jul 2005
Posts: 28

PostPosted: Tue Aug 23, 2005 11:25 pm    Post subject: Re: Regarding Sort Utility
Reply with quote

Hi Frank Yaeger,

Could u please send the material or suggest any books for tools(DFSORT,ICETOOL,....etc)

Because I am having just 3 months experience in Mainframes. So I dont know which book is better for tools.

Thanks in Advance.


Thanks & Regards
Hari.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Tue Aug 23, 2005 11:39 pm    Post subject:
Reply with quote

Hari,

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/servers/storage/support/software/sort/mvs/srtmpub.html
Back to top
View user's profile Send private message
harinatha

New User


Joined: 24 Jul 2005
Posts: 28

PostPosted: Tue Aug 23, 2005 11:45 pm    Post subject: Re: Regarding Sort Utility
Reply with quote

Hi Frank Yaeger,

Thanks for ur Help.
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 Innovations in Your Mainframe Sort Arun Raj PC Guides & IT News 4 Wed Mar 15, 2017 10:38 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts SORT requirement sjiraga COBOL Programming 6 Thu Mar 09, 2017 9:11 pm
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts SORT to append Month and YEAR in MMYY... tisamf DFSORT/ICETOOL 1 Wed Mar 08, 2017 4:46 pm


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