Virtual Field Type

LANSA Technical

previous page next page

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

previous page start next page