Clarification Needed in Sorting



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Clarification Needed in Sorting

Postby gowthamgyaa » Thu Oct 04, 2012 6:31 pm

Hi everyone,
I tried a SORT utility sorting has been done successfully but when i use sum fields i need some clarification. I'l provide you the statement below

//JOB STATEMENT
//STEPS EXEC PROG=SORT
//SYSPRINT DD SYSOUT=*
//SORTOUT DD SYSOUT=*
//SYSUT1 DD DSN=******.FINANCE.EMP,DISP=OLD
//SYSIN DD *
    SORT FIELDS=(4,2,CH,D)
    SUM FIELDS=(9,4,ZD)
/*
//



Record's in Finance.Emp
001 cse 1005
002 ece 1111
008 mec 1007
014 cse 1222
0777 aaa 1453
088 sss 1000
015 mmm 1005


Sortout
...
015 MMM 2012
..
..
..


For everyother things i got the sum fields correct, only to mmm i got 2012 , so what may be the prob. in this?

Kindly provide me a details

kind regard's
gyaa
gowthamgyaa
 
Posts: 101
Joined: Wed Sep 05, 2012 11:18 pm
Has thanked: 67 times
Been thanked: 0 time

Re: Clarification Needed in Sorting

 

Re: Clarification Needed in Sorting

Postby BillyBoyo » Thu Oct 04, 2012 6:40 pm

You have sorted on 4,2. Which is a blank, followed by three characters. Which means MMM and MEC get summed togther.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: Clarification Needed in Sorting

Postby gowthamgyaa » Thu Oct 04, 2012 7:07 pm

@Billy,
I am terribly sorry billy , the sort field's are (5,2,ch,D)
I also tried with sort fields (5,3,ch,D) but got the same results for both.
In my point of view ,as for with my novice knowledge i think the 2nd character in both mec and mmm are varying so it cant sum those two field's.
If any Mistakes in my thought kindly pardon me and guide me to a detailed explanation


Kind regard's
gyaa
gowthamgyaa
 
Posts: 101
Joined: Wed Sep 05, 2012 11:18 pm
Has thanked: 67 times
Been thanked: 0 time

Re: Clarification Needed in Sorting

Postby NicC » Thu Oct 04, 2012 7:19 pm

This is a sort question. Why are you posting in the JCL section? There are 2 sort sections - one for DFSORT and one for SYNCSORT. Which one are you using? SORT is NOT a valid answer. Check your SYSOUT messages - those beginning ICE are DFSORT and those beginning WER are SYNCSORT.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Re: Clarification Needed in Sorting

Postby gowthamgyaa » Thu Oct 04, 2012 7:27 pm

@ Nic,
pardon me Nic, as am a beginner i do no about what you said, i'l correct myself.


Kind regard's
gyaa
gowthamgyaa
 
Posts: 101
Joined: Wed Sep 05, 2012 11:18 pm
Has thanked: 67 times
Been thanked: 0 time

Re: Clarification Needed in Sorting

Postby NicC » Thu Oct 04, 2012 7:32 pm

What did you not understand? SYSOUT? Do you not recognise it as a DDNMAE from your job? It has messages written to it by the sort program. Read those messages. You do not actually need to check the message identifiers as one of the first lines will say which product it is.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic

These users thanked the author NicC for the post:
gowthamgyaa (Thu Oct 04, 2012 8:03 pm)
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Re: Clarification Needed in Sorting

Postby gowthamgyaa » Thu Oct 04, 2012 8:05 pm

@Nicc,
I understand about sysout, but i dint understand whats the relation with my SUMFIELD error & Types of sorting?

Kind regard's,
gyaa
gowthamgyaa
 
Posts: 101
Joined: Wed Sep 05, 2012 11:18 pm
Has thanked: 67 times
Been thanked: 0 time

Re: Clarification Needed in Sorting

Postby NicC » Thu Oct 04, 2012 8:12 pm

Because you are posting in the JCL part of the forum when you should be posting in one of the Sort sections. Tell me which sort product you are using and I will move the topic to the right place.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Re: Clarification Needed in Sorting

Postby gowthamgyaa » Thu Oct 04, 2012 8:23 pm

@Nicc,
Am using DFsort .


Kind regards
gyaa
gowthamgyaa
 
Posts: 101
Joined: Wed Sep 05, 2012 11:18 pm
Has thanked: 67 times
Been thanked: 0 time

Re: Clarification Needed in Sorting

Postby NicC » Thu Oct 04, 2012 8:31 pm

Thank you - topic moved. Just remember: JCL is a language and has all those pesky // at the start of each line - sometimes /* and sometimes //*. To refer to anything else as JCL is a no-no no matter what your instructor or future colleagues say.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Next

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post