|
View previous topic :: View next topic
|
| Author |
Message |
Sozhamadevi.K
New User
Joined: 09 Jan 2007
Posts: 1
Location: Chennai
|
|
|
|
| Input file has the Number in Pic X(10) format. ZD in Sum fields does'nt seem to work.The Data is in the format S9(x).9(y) format with an explicit '.'.Should we convert it before summing or is there any other way to resolve this? |
|
| Back to top |
|
 |
William Thompson
Global Moderator
Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ
|
|
|
|
| Sozhamadevi.K wrote: |
| Input file has the Number in Pic X(10) format. ZD in Sum fields does'nt seem to work.The Data is in the format S9(x).9(y) format with an explicit '.'.Should we convert it before summing or is there any other way to resolve this? |
If you have the manual or looked at some of these posts, you would realize that DFSORT can handle leading and trailing signs in addition to imbeded decimal points. |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
ZD cannot handle an embedded decimal point. You can use DFSORT's SFF format to convert the value to ZD, SUM it as ZD, and then convert it back to the original format. For details, see the "Sum a number with a decimal point" Smart DFSORT Trick at:
www.ibm.com/servers/storage/support/software/sort/mvs/tricks/ |
|
| Back to top |
|
|
|
|
