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:
- Review the concatenation extended definition of the virtual field currently being worked with.
- Specify the concatenation extended definition of the virtual field currently being worked with.
- Change the concatenation extended definition of the virtual field currently being worked with.
- Delete the concatenation extended definition of the virtual field currently being worked with. There is no confirm option when delete has been specified for a virtual field extended definition.
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.