3 3 2 Virtual Column Type

Show Contents List

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

Show Contents List