Virtual Field Type

Virtual Field Type

Mandatory.

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

Rules

Allowable values are:

3.3.2 Date Conversion	Map a date held in a real field in format (YYMMDD) into a virtual field in format (DDMMYY).
3.3.3 Substring	Substring 1 real field into multiple virtual fields
3.3.4 Concatenation	Substring multiple real fields into one virtual field
3.3.5 Mathematical Calculations	Specify the mathematical calculation extended definition of the virtual field currently being worked with.
3.3.6 Code Fragment	Allows you to specify RDMLX code to populate a virtual field when reading from a file, and to populate a real field when writing to a file.

 

 

Tips & Techniques

• The Virtual Field Name's type and length must be in agreement with the type of virtual field selected. For example, a numeric field type must be specified for a mathematical calculation. The field length is validated for only some types of virtuals. Check that the length of the field is correct for the virtual type selected.

Also See

Virtual Field Name

Ý 3.3 Virtual Fields in File