Data Conversion Errors

george.j.wen@us.abb.com george.j.wen@us.abb.com
Mon, 19 Nov 2001 11:43:04 -0600


I'm on PH 6.07F (AS/400) but this question may be gereric enough.
I'm processing Revenue/Cost lines with a Margin Percent in Quiz.
  Calcs and defines are pretty std.  Vis:
def REVENUE-AMT  float*8 = GLAA * -1
def MARGIN-AMT   float*8 = REVENUE-AMT - SDECST
*************************************************************************
Footing........................
tab 77  REVENUE-AMT Subtotal trailing "-" pic '¬¬¬,¬¬¬,¬¬¬.¬¬ '   &
tab 94  SDECST      Subtotal trailing "-" pic '¬¬¬,¬¬¬,¬¬¬.¬¬ '             &

tab 109 MARGIN-AMT  Subtotal trailing "-" pic '¬¬¬,¬¬¬,¬¬¬.¬¬ '     &
tab 124 MARGIN-AMT Percent REVENUE-AMT trailing "-" pic '¬¬¬¬.¬¬¬ '

I don't get any errors on the report but the statistic cite them:
     records selected : 100
     ** Data conversion errors: 220666
*************************************************************************
Revenue Amt   Cost Amt     Margin Amt   Percent
        34.88            270.00               235.12-             674.083-
     927.75         7,237.11            6,309.36-            680.071-
     390.68         3,224.88            2,834.20-            725.453-
     971.14         8,559.20            7,588.06-            781.356-
     163.89         1,897.75            1,733.86-          1057.941-
            .00         1,560.00            1,560.00-                   .000
  1,934.97         1,357.24               577.73              29.857
     580.20             337.58               242.62               41.817
  1,852.05          1,189.65              662.40               35.766
This sample contains some of the more unusual lines (warr) in the report
but there are no # signs to indicate data conversion errors and if I select  to
avoid getting negative Margin Amt's there's no difference in the result.

Anyone have an idea of where to look?

Thank you in advance
George