You are here: LANSA for i User Guide > 3. Files > 3.15 Virtual Fields > 3 15 5 Concatenation of Field s

3.15.5 Concatenation of Field(s)

This screen is displayed when the option to perform a Concatenation for a virtual field has been chosen from the Virtual field extended definition action box.

 

 

 DC@P201606          Concatenation of field(s)                         

                                                                       

 File : XXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX        (XXXX )

                                                                       

 Virtual field : XXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX   

                                                                       

 Derive "virtual" field on input from file . . .  ___  YES, NO         

 Setup "real" field before output to file  . . .  ___  YES, NO         

                                                                       

         Using fields                                                  

          __________                                                   

          __________                                                   

          __________                                                   

          __________                                                   

          __________ +                                                 

                                                                       

 Fnn=Help  Fnn=Exit  Fnn=Cancel  Fnn=Messages  Fnn=Change  Fnn=Delete  

                                                                       

 

 

Working from the Concatenation of field(s) screen you can:

Input Options

File Is the name of the physical file currently being worked with.

Virtual Field

Is the name of the "virtual" field within the physical file currently being worked with. The value of the "virtual" field will be the result of the concatenation of the fields specified in the "Using fields" list. The "virtual" field must be large enough to contain the result of the concatenation otherwise unpredictable results could occur.

Derive "Virtual" Field on Input From File

Specifies whether the "virtual" field should be derived from the file on input. Valid entries are "YES" or "NO".

Setup "Real" Field Before Output to File

Specifies whether the "real" field ("real" field can be either a "real" or "virtual" field name within this file) should be setup from the "virtual" field before output. Valid entries are "YES" or "NO".

Using Fields

Each field ("real" or "virtual" name within this file) specified will be joined together to form the "virtual" field. The accumulated length of all the specified fields must not exceed the total length of the "virtual" field. When the fields have been concatenated they will form the "virtual" field starting at position 1.

By entering a partial name or '?' the multiple field selection screen will be displayed. The selection list will be built from the real and virtual fields in the current file's definition. A maximum of 50 fields can be selected. Refer to 3.10.1 Select Fields When Working from File Definition Menu for more details.