The steps involved in defining, reviewing or changing virtual fields in a file definition are as follows:
1. Select the option to ___________
"Define virtual fields | |
in file definition" or | FILE |
"Review or change | DEFINITION|
virtual fields in file | MENU |
definition" from the |___________|
file definition menu. |
|
|
____|______
2. Define, review, change| |
or delete virtual | VIRTUAL |
fields defined in the | FIELDS |
file using the | IN FILE |
resulting display. |___________|
| \
| \___________
| |
3. Optionally review or _____|_____ _____|_____ Optionally
modify the extended | | | | review or
definition for the | VIRTUAL | | VIRTUAL | modify the
virtual field by | FIELD | OR | FIELD | RPG/400 code
specifying the type of | EXTENDED | | RPG CODE | that is used
action to derive the |DEFINITION | |___________| to derive
virtual fields. |___________| virtual field
__________________/ / \ \_________________
| ______/ \_____ |
| | | |
____|_____ _____|_____ _____|_____ _____|_____
| | | | | | | |
|SUBSTRING | | CONCAT'S | | MATHS | | DATE |
| | OR | | OR |CALCULATION| OR |CONVERSION |
| | | | | | | |
|__________| |___________| |___________| |___________|
4. Derive Derive virtual Derive virtual Derive virtual
virtual field field by a field by a field by a
by substringing concatenation mathematical date conversion
a field/record of fields calculation of a field