|
INCREMENT |
Scroll |
The INCREMENT function adds one (1) to a number, usually a value being used as a counter.
Category
Mathematical
Syntax
INCREMENT(numeric_value)
Parameter Descriptions
numeric_value - A numeric value from a source datastore field/column, user specified numeric value constant or the numeric result of another Function.
Example
Increment the field COUNTER by 1 and map the result to target field RCD_COUNT. Assume that the value of COUNTER, prior to the INCREMENT operation, is equal to 10.
RCD_COUNT = INCREMENT (COUNTER)
Returns the value of 11.
Increment the number 25 by 1 and store the result in target field RCD_COUNT.
RCD_COUNT = INCREMENT (25)
Returns the value of 26.
