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 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.