Please enable JavaScript to view this site.

The FLDMAX examines a set of values and returns the largest value in the set.

Category

Specialized

Syntax

FLDMAX(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 largest of the following values:

NUM1 = 10

NUM2 = 20

NUM3 = 30

NUM4 = 25

Map the largest value to target field TGT_HIGHVAL.

 

TGT_HIGHVAL = FLDMAX (NUM1,  NUM2,  NUM3,  NUM4)

 

Returns the value of 30.