The INCREMENT function adds one (1) to a number, usually a value being used as a counter.
Category
Mathematical
Syntax
INCREMENT(numeric_value)
Parameter and Description
| Parameter | Description |
|---|---|
| numeric value | A numeric value from a source datastore field/column, user specified numeric value or the numeric result of another Function. |
Example 1
Increment the source 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.
Example 2
Increment the number 25 by 1 and store the result in target field RCD_COUNT.
RCD_COUNT = INCREMENT (25)
Returns the value of 26.