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

Regarding Sort Utility


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
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
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

Global Moderator


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

PostPosted: Mon Aug 22, 2005 10:30 pm
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 Developer


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

PostPosted: Mon Aug 22, 2005 11:42 pm
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:

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
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: 463

PostPosted: Tue Aug 23, 2005 12:00 pm
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
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 Developer


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

PostPosted: Tue Aug 23, 2005 9:16 pm
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
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 Developer


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

PostPosted: Tue Aug 23, 2005 11:39 pm
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:

Use [URL] BBCode for External Links
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts JCL sort card - get first day and las... JCL & VSAM 9
No new posts REASON 00D70014 in load utility DB2 6
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
No new posts how to calculate SUM value for VB fil... DFSORT/ICETOOL 1
Search our Forums:

Back to Top