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.

...

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              Smith" and Surname was "John               John", a simple concatenation virtual would create a virtual column called FULLNAME with a result of  "Smith              John               Smith John".

Using the following code fragment:

...

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

...

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