Neoview SQL Reference Manual (R2.4)

MOD Function
The MOD function returns the remainder (modulus) of an integer value expression divided by
an integer value expression.
MOD is a Neoview SQL extension.
MOD (integer-expression-1,integer-expression-2)
integer-expression-1
is an SQL numeric value expression of data type SMALLINT, INTEGER, or LARGEINT that
specifies the value for the dividend argument of the MOD function.
integer-expression-2
is an SQL numeric value expression of data type SMALLINT, INTEGER, or LARGEINT that
specifies the value for the divisor argument of the MOD function. The divisor argument
cannot be zero.
See “Numeric Value Expressions” (page 250).
Example of MOD
This function returns the value 2 as the remainder or modulus:
MOD (11,3)
MOD Function 405