Concatenation Example

LANSA Technical

Concatenation Example

Following is an example of a concatenation virtual field.

The Employee file contains the employee's last name in a field SURNAME defined as A(20).

The Employee file contains the employee's first name in a field GIVENAME defined as A(20).

A concatenation virtual field can be created named FULLNAME defined as A(40). This field will have the first name followed by the last name:

Virtual Field Name: FULLNAME

Field Names

Length

Description

GIVENAME

20

Employee Given Name

SURNAME

20

Employee Surname

 

 

Also see

3.3.6 Code Fragment

Ý 3.3.4 Concatenation