IBM Mainframe Forum

by **speermb** » Fri Sep 21, 2012 6:14 pm

I have file like:

Select all

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.

Select all

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

However I am only get to ones that are 0.

Select all

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?

by **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.

by **speermb** » Fri Sep 21, 2012 7:00 pm

Thanks, that worked. I just need to remenber to account for all decimal places.

IBM Mainframe Forum

Comparing a PD field to a decimal Constant

Comparing a PD field to a decimal Constant

Re: Comparing a PD field to a decimal Contast

Re: Comparing a PD field to a decimal Constant