3.3.1 Virtual Column Name
Mandatory.
Specify the name of a field that is to be included in the table definition as a virtual column.
Rules
- A column used in a table definition must be defined in the LANSA Repository.
- The column type must be in agreement with the 3.3.2 Virtual Column Type selected. For example, a numeric column type must be specified for a mathematical calculation.
- The column length is validated for substring and concatenation derivations.
Tips & Techniques
- Follow the column naming standards when using virtual columns. For example, name all virtual columns with a 3 character suffix of "VIR". This will help developers identify a column as a virtual column.