Comparing a PD field to a decimal Constant



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Comparing a PD field to a decimal Constant

Postby speermb » Fri Sep 21, 2012 6:14 pm

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?
speermb
 
Posts: 6
Joined: Thu Nov 05, 2009 9:01 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Comparing a PD field to a decimal Constant

 

Re: Comparing a PD field to a decimal Contast

Postby BillyBoyo » Fri Sep 21, 2012 6:36 pm

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.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: Comparing a PD field to a decimal Constant

Postby speermb » Fri Sep 21, 2012 7:00 pm

Thanks, that worked. I just need to remenber to account for all decimal places.
speermb
 
Posts: 6
Joined: Thu Nov 05, 2009 9:01 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post