Adding negative ZD with DFSORT

satya12 · New User Joined: 25 Apr 2006 Posts: 32 Location: India

Hi

I am trying to sum fields on ZD and my file has some records with negative values.Looks like DFOSRT is not recogizing the negative sign which adding the amounts.

murmohk1 · Posted: Sat Nov 03, 2007 7:56 am

satya,

Try SFF (Signed free format) in place of ZD.

satya12 · New User Joined: 25 Apr 2006 Posts: 32 Location: India

I don't think we can use SFF in sum fields option.

I tried n getting an error message saying invalid format.

I tried another option of conveting ZP to PD and then sum up the PD field.But no luck.

murmohk1 · Posted: Sat Nov 03, 2007 12:46 pm

Satya,

krisprems · Posted: Sat Nov 03, 2007 12:57 pm

satya12
Look at this example
http://ibmmainframes.com/viewtopic.php?t=25352

Frank Yaeger · Posted: Sat Nov 03, 2007 8:56 pm

Satya,

DFSORT recognizes negative signs for ZD values just fine. But your values are NOT ZD values.

A 9-byte negative ZD value would look like this:

X'FdFdFdFdFdFdFdFdDd'

whereas your values have a leading floating sign and leading zeros suppressed. Actually, your values are FS values, not ZD values.

You can't use FS for SUM, but you can do what you want using OUTFIL SECTIONS instead of SUM. Here's a DFSORT job that will do what you want:

satya12 · New User Joined: 25 Apr 2006 Posts: 32 Location: India

Yup

Both SFF and FS worked when i tried them in the trailer section with TOT option.

Thanks a lot guys

Have a greta weekend.

Frank Yaeger · Posted: Sun Nov 04, 2007 10:12 pm

Yes, both work, but less processing is required for FS than SFF, so in general FS is more efficient than SFF. FS is the better choice for values like

-123456789

whereas SFF is required for values like

-1,234,567.89

for which FS cannot be used.