Please enable JavaScript to view this site.

The DECREMENT function subtracts one (1) from a number. This function can be used to decrement a counter that may be used for tasks such as loop control.

Category

Mathematical

Syntax

DECREMENT(numeric_value)

 

Parameter Descriptions

numeric value  -  A numeric value from a source datastore field/column, user specified numeric value or the numeric result of another Function.

Example

Decrement the source field COUNTER by 1 and map the result to target field RCDS_LEFT. Assume that the value of Counter, prior to the DECREMENT operation, is equal to 10.

TARGET_DS.RCDS_LEFT  = DECREMENT (COUNTER)

Returns the value of 9.

 

Decrement the number 25 by 1 and map the result to target field DECR_VALUE.

DECR_VALUE = DECREMENT (25)

Returns the value of 24.