julienloc
New User
Joined: 17 Aug 2007 Posts: 29 Location: Brussels
|
|
|
|
Hi all,
Can DFSORT sum fields containing numbers in the following format?
+000000000013,000
-000000000001,713
-000000000059,000
That is, the sign is in front and the decimal part is separated by a ',' (comma).
Thanks.
Julien |
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
You can use DFSORT's SFF format for those types of numbers. You can get a total for these values with a DFSORT job like this:
Code: |
//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD *
+000000000013,000
-000000000001,713
-000000000059,000
//SORTOUT DD SYSOUT=*
//SYSIN DD *
OPTION COPY
OUTFIL REMOVECC,NODETAIL,
TRAILER1=(TOT=(1,17,SFF,EDIT=(STTTTTTTTTTTT,TTT),SIGNS=(+,-)))
/*
|
SORTOUT would have:
|
|