View previous topic :: View next topic
|
Author |
Message |
Mariraj
New User
Joined: 09 Jul 2007 Posts: 59 Location: Chennai
|
|
|
|
I am using summation based on a 3-digit ZD field. The results are perfectly fine except that the last digit of the summed field is displayed as ‘E’ instead of ‘5’. When I do a ‘HEX ON’ on the output DS, the following is displayed. I am referring to the '18E' field.
Code: |
8001 BILL 18E 890106 10
FFFF4CCDD444FFC4FFFFFF4FF44444444444444444444444444444444444444444444444
800102933000185089010601000000000000000000000000000000000000000000000000 |
In HEX format, the data is proper. It contains C in the last nibble to indicate it is a positive value. But I m not sure why is it displaying ‘E’ instead of ‘5’. Please let me know the reason. I tried searching this forum but couldn't find an exact match. Please excuse me if it is a duplicate post and also let me know the post link. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
Back to top |
|
|
Mariraj
New User
Joined: 09 Jul 2007 Posts: 59 Location: Chennai
|
|
|
|
Thanks for the info. So this means whenever the result is a postive value, it wil be only A,B,C... based on whether it is +1,+2,..
Can you tell me how can we make it to display 185 instead of 18E. Do we need to change the format? If so what should be the format? |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
quoting one of Frank Yaeger posts
Quote: |
If you are getting a C sign for Zd instead of an F sign, then you're using Syncsort, not DFSORT. DFSORT gives an F sign for TO=ZD. Try using TO=ZDF. And since you're using Syncsort, please post in the JCL Forum, not in the DFSORT Forum. |
please confirm and I will move the topic where it belongs...
messages starting with ...
ICE... ==> DFSORT
WER... ==> SYNCSORT |
|
Back to top |
|
|
Mariraj
New User
Joined: 09 Jul 2007 Posts: 59 Location: Chennai
|
|
|
|
Messages are starting with ICE only |
|
Back to top |
|
|
hikaps14
Active User
Joined: 02 Sep 2005 Posts: 189 Location: Noida
|
|
Back to top |
|
|
Mariraj
New User
Joined: 09 Jul 2007 Posts: 59 Location: Chennai
|
|
|
|
I tried using the following.
Code: |
OUTREC FIELDS=(1,12,13,3,ZD,EDIT=(TTT),16) |
This helped to achieve what i wanted to i.e see the result as 185. Thanks to both of you. |
|
Back to top |
|
|
Skolusu
Senior Member
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
|
|
|
|
Mariraj,
Since you are summing the default option at your shop may be NZDPRINT. Use the ZDPRINT option which will print the F sign. You don't have to use OUTREC with EDIT
ex:
Code: |
//SYSIN DD *
OPTION ZDPRINT
SORT FIELDS=(p,m,CH,A)
SUM FIELDS=(p,3,ZD)
//* |
|
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Quote: |
quoting one of Frank Yaeger posts
Quote:
If you are getting a C sign for Zd instead of an F sign, then you're using Syncsort, not DFSORT. DFSORT gives an F sign for TO=ZD. Try using TO=ZDF. And since you're using Syncsort, please post in the JCL Forum, not in the DFSORT Forum. |
This was quoted out of context. I was talking about TOTAL, not SUM. For SUM, ZDPRINT=YES/NO (ZDPRINT/NZDPRINT) controls the sign. |
|
Back to top |
|
|
|