Concatenated Column Names

Mandatory.

Specify each column (real or virtual) in the physical table to be joined together to form the virtual column nominated in the 3.3.1 Virtual Column Name.

When the columns have been concatenated, they will form the virtual column starting at position 1.

Rules

• One or more columns must be identified.

• Columns may be real columns, virtual columns or Predetermined Join Columns from the table definition.

Tips & Techniques

• The column defined in the 3.3.1 Virtual Column Name must be of sufficient length to hold the concatenated columns.

• If you are using Predetermined Join Columns to create the virtual column, you must specify that the PJC derivation is Before virtual columns in the 3.5.10 Derivation of the Access Route Definitions.

Also See

Concatenation Example