Page 1 of 1

Comparing a PD field to a decimal Constant

PostPosted: Fri Sep 21, 2012 6:14 pm
by speermb
I have file like:
GPA069C2-AMOUNT-DIFF
9/PS                 
(231-239)           
29------------------
DATA ****************
                0.04
               -0.01
               -0.01
 


I want to include any records that GPA069C2-AMOUNT-DIFF is between +1 & -1.

INCLUDE COND=(231,9,PD,LT,+1,AND,231,9,PD,GT,-1) 


However I am only get to ones that are 0.
GPA069C2-AMOUNT-DIFF
9/PS                 
(231-239)           
29------------------
DATA ****************
                   0
                   0
                   0
                   0
                   0
                   0
                   0
                   0
                   0
                   0
                   0
                   0
                   0
                   0
                   0
                   0

What am I doing incorrectly?

Re: Comparing a PD field to a decimal Contast

PostPosted: Fri Sep 21, 2012 6:36 pm
by BillyBoyo
Because you are looking "somewhere else" and seeing a decimal point, you have convinced yourself that DFSort knows the field has a decimal point.

However, it doesn't. So, try with +100 and -100.

Re: Comparing a PD field to a decimal Constant

PostPosted: Fri Sep 21, 2012 7:00 pm
by speermb
Thanks, that worked. I just need to remenber to account for all decimal places.