View previous topic :: View next topic
|
Author |
Message |
sravanv
New User
Joined: 02 Aug 2005 Posts: 13 Location: hyderabad
|
|
|
|
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 |
|
|
superk
Global Moderator
Joined: 26 Apr 2004 Posts: 4652 Location: Raleigh, NC, USA
|
|
|
|
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 |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
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 |
|
|
elonics
New User
Joined: 05 Jul 2005 Posts: 49 Location: India
|
|
|
|
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 |
|
|
Rupesh.Kothari
Member of the Month
Joined: 27 Apr 2005 Posts: 463
|
|
|
|
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 |
|
|
elonics
New User
Joined: 05 Jul 2005 Posts: 49 Location: India
|
|
|
|
Hi ,
I asked why should we use that, but not what will happen if we use that.
Regards,
Elonics. |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
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.
DFSORT does support the same function (and more) with ICETOOL using different syntax. |
|
Back to top |
|
|
harinatha
New User
Joined: 24 Jul 2005 Posts: 28
|
|
|
|
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 |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
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 |
|
|
harinatha
New User
Joined: 24 Jul 2005 Posts: 28
|
|
|
|
Hi Frank Yaeger,
Thanks for ur Help. |
|
Back to top |
|
|
|