IBM Integration Bus, Version 10.0.0.0 Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS


MOD function

The MOD numeric function returns the remainder when dividing two numbers.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-MOD--(--dividend--,--divisor--)-----------------------------><

MOD returns the remainder when the first parameter is divided by the second parameter. The result is negative only if the first parameter is negative. Parameters must be integers. The function returns an integer. If any parameter is NULL, the result is NULL.

For example:
MOD(7, 3)
returns 1
MOD(-7, 3)
returns -1
MOD(7, -3)
returns 1
MOD(6, 3)
returns 0

ak05370_.htm | Last updated 2015-03-27 19:26:53