Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

[ Image Removed |../../index.htm#lansa/l4wtgu03_0295.htm]
You are here:

...

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 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
[ Image Removed |../../index.htm#lansa/l4wtgu03_0295.htm]