Subject | RE: [IBO] retrieving size and precision of numeric fields |
---|---|

Author | Salim Naufal |

Post date | 2003-06-09T08:37:12Z |

Hi Peter,

You are correct that 100 cannot be divided by three. The rounding is done by

the TBCD fields and therefore, you should get 33.33 for the first two credit

fields and then, to compensate, I get the difference and store it in the

third credit field. In this case, I get 33.34 for the third field. The point

is that the rounding is done in IBX to 2 digits which is what matched the

numeric(18,2) and in IBO to 4 digits which is incorrect.

You are correct that 100 cannot be divided by three. The rounding is done by

the TBCD fields and therefore, you should get 33.33 for the first two credit

fields and then, to compensate, I get the difference and store it in the

third credit field. In this case, I get 33.34 for the third field. The point

is that the rounding is done in IBX to 2 digits which is what matched the

numeric(18,2) and in IBO to 4 digits which is incorrect.