3.3.2 Virtual Column Type
Mandatory.
Specify the type of derivation to be used for the virtual column.
Rules
Allowable values are:
|
3.3.6 Date Conversion
|
Map a date held in a real column in format (YYMMDD) into a virtual column in format (DDMMYY).
|
|
3.3.7 Substring
|
Substring 1 real column into multiple virtual columns
|
|
3.3.8 Concatenation
|
Substring multiple real columns into one virtual column
|
|
3.3.9 Mathematical Calculations
|
Specify the mathematical calculation extended definition of the virtual column currently being worked with.
|
|
3.3.10 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
- The 3.3.1 Virtual Column Name's type and length must be in agreement with the type of virtual column selected. For example, a numeric column type must be specified for a mathematical calculation. The column length is validated for only some types of virtuals. Check that the length of the column is correct for the virtual type selected.
Also See
3.3.1 Virtual Column Name
