Problem with 'SUM FIELDS' in dfsort.

bijoybabu83 · New User Joined: 15 Jan 2007 Posts: 36 Location: Kerala

I am trying to do a 'SUM FIELD' sort shown below: -

//STEP01 EXEC PGM=SORT
//STEPLIB DD DSN=SYS1.SORTLIB,DISP=SHR
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=IHC$017.CBF.EXTRACT.FIL,
// DISP=SHR
//SORTOUT DD DSN=IHC$017.CBF.EXTRACT.FIL99,
// DISP=(NEW,CATLG,DELETE),
// SPACE=(125,(12,1),RLSE),
// DCB=(LRECL=133,DSORG=PS,RECFM=FM)
//SYSIN DD *
SORT FIELDS=(9,3,ZD,A)
SUM FIELDS=(79,10,ZD)
/*
//

However for two records which has to be summed based on this, the field values are 0000000057 and 0000000057.

However the summed value in the output file is '000000010D' instead of '0000000104'. However once i do hex on, the hex values are showing 104.

Can anyone tell what is the problem and how to eliminate this problem.

Frank Yaeger · Posted: Mon Oct 12, 2009 8:57 pm

Add the following to SYSIN:

bijoybabu83 · New User Joined: 15 Jan 2007 Posts: 36 Location: Kerala

Thank you so much frank...It worked now.

Can you please tell what is 'F' sign and 'C' sign in DFSORT. Kindly Bear with me for bugging you...

Frank Yaeger · Posted: Tue Oct 13, 2009 9:20 pm

A 3-byte ZD value looks like this in hex:

zdzdsd

where z is the zone (usually F), d is a digit (0-9) and s is the sign.

Normally, for ZD fields, the sign is C or F for positive and D for negative. Both C and F are valid signs for positive ZD values. If the F sign is used for positive values, then the value is "displayable" - for example, +123 would be X'F1F2F3' = '123'. If the C sign is used for positive values, then value is not displayable - for example, +123 would be X'F1F2C3' = '12C'.