Code Fragment Virtual Column Derivation

A code fragment does not support the full range of RDML/X commands. In Version 11, the user is limited to constructs such as If, Case, Dountil, Dowhile, Change, Assign.

At execution time, the code fragment will have read only access to all columns in the table.

In the following example, the xEmployee table has two columns Surname and GivenNames. Surname is A(20) and GivenNames is A(20). If the Surname was "Smith              " and Surname was "John               ", a simple concatenation virtual would create a virtual column called FULLNAME with a result of  "Smith              John               ".

Using the following code fragment:

#FULLNAME := #SURNAME + ', ' + #GIVENAME

 

the code fragment virtual column FULLNAME will have a result of "Smith, John".