max_elem_alldefined
Ordering functions maximum element alldefined
syntax
- max_elem_alldefined(a, b, .. , n)
definition
max_elem_alldefined(a, b, .. , n) is a variant of the Max_elem function resulting in defined values if all values of the arguments for an entry in the Domain unit are defined. If any argument contains Null values, the resulting value for that entry will become null.
example
attribute<int32> max_elem_alldefinedABC (MDomain) := max_elem_alldefined(A, B, C);
| A(int32) | B(int32) | C(int32) | max_elem_alldefinedABC |
|---|---|---|---|
| 0 | 1 | 2 | 2 |
| 1 | -1 | 4 | 4 |
| -2 | 2 | 2 | 2 |
| 4 | 0 | 7 | 7 |
| 999 | 111 | -5 | 999 |
| 2 | null | 1 | null |
| 0 | 1 | null | null |
| null | 1 | 2 | null |
| null | null | null | null |
MDomain, nr of rows = 9