IBM Mainframe Forum

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




Record's in Finance.Emp


Sortout


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

You have sorted on 4,2. Which is a blank, followed by three characters. Which means MMM and MEC get summed togther.

@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

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.

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


Kind regard's
gyaa

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.

These users thanked the author NicC for the post:

gowthamgyaa (Thu Oct 04, 2012 8:03 pm)

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

Kind regard's,
gyaa

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.

@Nicc,
Am using DFsort .


Kind regards
gyaa

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.