|
MOD |
Scroll |
The MOD function returns the Integer remainder after dividing one number by another (the modulus).
Category
Mathematical
Syntax
MOD(data_element, variable_name | constant)
Parameter Descriptions
data_element - A field/column within a source datastore or Cursor results. Data_element_1 is also referred to as the dividend.
variable_name | constant - This parameter specifies a variable or constant, also referred to as the divisor, that will be divided into data_element to calculate a remainder.
Example
Find the database partition number for a 10 partition database numbered 0-9 using the customer number CUST_NUM and map the result to the target field PARTITION_NUM. Assume that the CUST_NUM is 1234567.
PARTITION_NUM = MOD (CUST_NUM, 10)
Returns the value 7 and maps it to the target field.
