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.

Also See

3.2 Real Columns in Table