Concatenation Field Examples
This screen demonstrates the use of the "Concatenation of field(s)" option and how it may be used in joining together a number of fields (real or virtual) to form a virtual field after input from a file.
Using the idea of the chart of accounts example we will switch the real and the virtual fields around so we now have 3 "real" fields COMPNO (alpha length 2), DIVNUM (alpha length 2) and COSTCT (alpha length 4) and join them together to form the "virtual" field CHTACC (alpha length 8):
|
DC@P201606 Concatenation of field(s)
File: ACCMST Accounts Master file
Virtual field: CHTACC Chart of accounts number
Derive "virtual" field on input from file . . . YES YES, NO Setup "real" field before output to file . . . NO YES, NO
Using fields COMPNO DIVNUM COSTCT
+
Fnn=Help Fnn=Exit Fnn=Cancel Fnn=Messages Fnn=Change Fnn=Delete
|