Result

Mandatory.

Specify the result virtual column or a *WORKnnnnn field that will be used in a mathematical expression of:

     Factor1  (Operator) Factor2 = Result

Rules

The *WORKnnnnn fields are exclusively reserved for use in "virtual" code extended definition "mathematical calculations" only.
The *WORKnnnnn fields do not have to be defined within LANSA, the *WORKnnnnn field length will be automatically assumed to 30, 9 if the machine is an IBM i.
All *WORKnnnnn fields that are used in a mathematical calculation are automatically initialized before the first time they are used.
Multiple *WORKnnnnn fields can be used in mathematical calculations simply by replacing the nnnnn portion of the work field name with a unique replacement value.
If *WORKnnnnn fields with the same name are used in other virtual columns' mathematical calculations, their values will not be carried forward to the next virtual column's mathematical calculation.

IBM i: The *WORKnnnnn fields do not have to be defined within LANSA, the *WORKnnnnn field length will be automatically assumed to 30, 9 if the machine is an IBM i.
Other platforms: Virtual column calculations support a maximum of 15 digits precision. This means that if the contents of the field in Factor 1, Factor 2 are more than 15 digits, or the result would exceed 15 digits, this will result in an error and/or an incorrect result. To avoid this, if the table is RDMLX, use an RDMLX code fragment. If the table is RDML, use a trigger function to calculate the result field. RDML mathematics will work correctly in a trigger function on all platforms.