3.3.10 Code Fragment

The code fragment virtual column allows you to specify RDMLX code to populate a virtual column when reading from a table, and to populate a real column when writing to a table.

...

In the following example, only the first option is selected, so only the Virtual Column Derivation tab is shown:

Image AddedImage Removed
When both options are selected both tabs appear:

Image AddedImage Removed
When only the second option is selected, only the Real Column Derivation tab is shown:

Image RemovedImage Added

Code fragment vs concatenation

Code fragments give you more control and variability than concatenation. The following example of Concatenation uses the same information to derive the real and the virtual column (simply by applying reverse of definition) and gives you a similar but not quite the same result.

...

Concatenation of Surname and Full name would give TurnerScott

Image RemovedImage Added

Also see

Code Fragment Virtual Column Derivation
Code Fragment Real Column Derivation
3.3.8 Concatenation