Virtual Column Type

Mandatory.

Specify the type of derivation to be used for the virtual column.

Rules

Allowable values are:

3.3.2 Date Conversion

Map a date held in a real column in format (YYMMDD) into a virtual column in format (DDMMYY).

3.3.3 Substring

Substring 1 real column into multiple virtual columns

3.3.4 Concatenation

Substring multiple real columns into one virtual column

3.3.5 Mathematical Calculations

Specify the mathematical calculation extended definition of the virtual column currently being worked with.

3.3.6 Code Fragment

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.

 

 

Tips & Techniques

Also See

Virtual Column Name