Specify the result virtual column or a *WORKnnnnn field that will be used in a mathematical expression of:
Factor1 (Operator) Factor2 = Result
Rules
The final result in the calculation must be the defined virtual column.
Tips & Techniques
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.
Platform Considerations
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.