Performing Operations on Decimal Data

The ESQL/C function library provides the following functions to perform arithmetic operations on DECIMAL (mi_decimal) and MONEY (mi_money) values.

Function Name

Description

decadd( )

Adds two mi_decimal numbers

deccmp( )

Compares two mi_decimal numbers

deccopy( )

Copies a mi_decimal number

decdiv( )

Divides two mi_decimal numbers

decmul( )

Multiplies two mi_decimal numbers

decround( )

Rounds an mi_decimal number

decsub( )

Subtracts two mi_decimal numbers

dectrunc( )

Truncates an mi_decimal number

Any other operations, modifications, or analyses can produce unpredictable results.