The FLDMIN examines a set of values and returns the smallest value in the set.
Category
Specialized
Syntax
FLDMIN(value1, value2 [, valuen])
Parameter and Description
| Parameter | Description |
|---|---|
| value (1-n) | Two (2) or more values from a source datastore field/column, user specified numeric value or the numeric result of another Function. |
Example
Determine the largest of the following values:
NUM1 = 10
NUM2 = 20
NUM3 = 30
NUM4 = 25Map the largest value to target field TGT_LOWVAL.
TGT_LOWVAL = FLDMIN (NUM1, NUM2, NUM3, NUM4, 12, 21)
Returns the value of 10.