Please enable JavaScript to view this site.

The FLDMIN examines a set of numeric values and returns the smallest number in the set.

Category

Specialized

Syntax

FLDMIN(value1, value2 [, valuen])

 

Parameter Descriptions

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 smallest of the following values:

NUM1 = 10

NUM2 = 20

NUM3 = 30

NUM4 = 25

 

Map the largest value to target field TGT_LOWVAL.

 

TGT_LOWVAL = FLDMIN (NUM1,  NUM2,  NUM3,  NUM4, 12, 21)

 

Returns the value of 10.